Dataset info
| Number of variables | 180 |
|---|---|
| Number of observations | 51739 |
| Missing cells | 0 (0.0%) |
| Duplicate rows | 0 (0.0%) |
| Total size in memory | 71.1 MiB |
| Average record size in memory | 1.4 KiB |
Variables types
| Numeric | 41 |
|---|---|
| Categorical | 57 |
| Boolean | 71 |
| Date | 0 |
| URL | 0 |
| Text (Unique) | 0 |
| Rejected | 11 |
| Unsupported | 0 |
Warnings
COMM_TKT_DT has a high cardinality: 449 distinct values | Warning |
COMM_VINTAGE_SCORE has 38587 (74.6%) zeros | Zeros |
DELIVERY_STATUS is highly skewed (γ1 = 102.1243294) | Skewed |
DELIVERY_STATUS has 39794 (76.9%) zeros | Zeros |
DUE_DATE_PAID has a high cardinality: 456 distinct values | Warning |
DUE_DATE_SYS has 40287 (77.9%) zeros | Zeros |
DUE_STS_SYS is highly correlated with DUE_DATE_SYS (ρ = 0.9585905194) | Rejected |
DUE_VINTAGE_SCORE has 40833 (78.9%) zeros | Zeros |
HELP_LINE_ACCOUNTVALUE/SURRENDERVALUE is highly skewed (γ1 = 26.97999883) | Skewed |
HELP_LINE_ACCOUNTVALUE/SURRENDERVALUE has 50853 (98.3%) zeros | Zeros |
HELP_LINE_BONUSINQUIRY has 51428 (99.4%) zeros | Zeros |
HELP_LINE_DUEDATE/AMOUNT has 49366 (95.4%) zeros | Zeros |
HELP_LINE_LOANENQUIRY is highly skewed (γ1 = 39.97374162) | Skewed |
HELP_LINE_LOANENQUIRY has 51597 (99.7%) zeros | Zeros |
HELP_LINE_OTHERS has 49496 (95.7%) zeros | Zeros |
HELP_LINE_POLICYPACKDISPATCHSTATUS/CLARIFICATION has 51388 (99.3%) zeros | Zeros |
HELP_LINE_POLICYSTATUS-ACTIVE/LAPSE has 50342 (97.3%) zeros | Zeros |
HELP_LINE_POSREQUESTSTATUSREQUIRED has 50977 (98.5%) zeros | Zeros |
HELP_LINE_PREMIUMPAYMENT/CHEQUERECEIVEDENQUIRY has 50568 (97.7%) zeros | Zeros |
HELP_LINE_PROBABLESURRENDER is highly skewed (γ1 = 22.69337676) | Skewed |
HELP_LINE_PROBABLESURRENDER has 51481 (99.5%) zeros | Zeros |
HELP_LINE_STATUSOFTHEPROPOSAL is highly skewed (γ1 = 31.94253099) | Skewed |
HELP_LINE_STATUSOFTHEPROPOSAL has 51457 (99.5%) zeros | Zeros |
IVR_ACCOUNT_VALUE/_SURRENDER_VALUE is highly skewed (γ1 = 62.98743417) | Skewed |
IVR_ACCOUNT_VALUE/_SURRENDER_VALUE has 51603 (99.7%) zeros | Zeros |
IVR_OTHERS has 51048 (98.7%) zeros | Zeros |
IVR_POLICY_STATUS_-_ACTIVE_/_LAPSE is highly skewed (γ1 = 23.17915677) | Skewed |
IVR_POLICY_STATUS_-_ACTIVE_/_LAPSE has 51082 (98.7%) zeros | Zeros |
IVR_PREMIUM_RECEIPT_REQUEST is highly skewed (γ1 = 22.87083409) | Skewed |
IVR_PREMIUM_RECEIPT_REQUEST has 51542 (99.6%) zeros | Zeros |
mapped_pol_id has a high cardinality: 48127 distinct values | Warning |
MEGA_MEGA_OTHERS is highly skewed (γ1 = 35.4290705) | Skewed |
MEGA_MEGA_OTHERS has 51167 (98.9%) zeros | Zeros |
MON_BNC_CHQ_VINTAGE_SCORE has 46838 (90.5%) zeros | Zeros |
MON_BOUNCE_COUNT has 46655 (90.2%) zeros | Zeros |
MON_CLEARANCE_COUNT is highly skewed (γ1 = 22.83197841) | Skewed |
MON_CLEARANCE_COUNT has 40667 (78.6%) zeros | Zeros |
MON_CLR_CHQ_VINTAGE_SCORE has 41055 (79.4%) zeros | Zeros |
MON_TKT_BOUNCE_DATE has a high cardinality: 324 distinct values | Warning |
MON_TKT_CLEARNACE_DATE has a high cardinality: 367 distinct values | Warning |
MY_MON_BNC_SYS is highly correlated with MON_BOUNCE_COUNT (ρ = 0.948047586) | Rejected |
PLAN_FAMILY_04 is highly correlated with PLAN_CAT_02 (ρ = 0.9697120372) | Rejected |
PLAN_TYPE_03 is highly correlated with PLAN_CAT_01 (ρ = 1) | Rejected |
PLAN_TYPE_05 is highly correlated with PLAN_FAMILY_07 (ρ = 0.9173916105) | Rejected |
PLAN_TYPE_07 is highly correlated with PLAN_FAMILY_14 (ρ = 1) | Rejected |
POL_COV_TERM has 15185 (29.3%) zeros | Zeros |
POL_PPT has 15184 (29.3%) zeros | Zeros |
POL_RIDER_COUNT has 32092 (62.0%) zeros | Zeros |
POLICY_CHNL_04 is highly correlated with PLAN_TYPE_03 (ρ = 0.9023277115) | Rejected |
POS_COUNT has 46128 (89.2%) zeros | Zeros |
POS_TKT_LOGGED_DATE1 has a high cardinality: 389 distinct values | Warning |
POS_VINTAGE_SCORE has 46302 (89.5%) zeros | Zeros |
REN_COUNT has 42428 (82.0%) zeros | Zeros |
REN_TKT_LOGGED_DATE1 has a high cardinality: 390 distinct values | Warning |
REN_VINTAGE_SCORE is highly correlated with REN_SYS_TOUCH_PT (ρ = 0.9115846582) | Rejected |
SCP_EML_SCP_EML_OTHERS has 45668 (88.3%) zeros | Zeros |
SCP_SMS_AGENT_-_OTHER is highly skewed (γ1 = 29.00202748) | Skewed |
SCP_SMS_AGENT_-_OTHER has 51665 (99.9%) zeros | Zeros |
SCP_SMS_LAPSATION_&_REVIVAL has 50680 (98.0%) zeros | Zeros |
SCP_SMS_PAYMENT_MODE has 45989 (88.9%) zeros | Zeros |
SCP_SMS_POS has constant value "0" | Rejected |
SCP_SMS_PREMIUM_PAYMENT has 44806 (86.6%) zeros | Zeros |
SCP_SMS_PROPOSAL has 48857 (94.4%) zeros | Zeros |
SCP_SMS_RENEWAL has 50360 (97.3%) zeros | Zeros |
TICKET_DATE has a high cardinality: 404 distinct values | Warning |
TICKET_DATE_15D has a high cardinality: 404 distinct values | Warning |
TKT_LOGGED_DATE has a high cardinality: 51631 distinct values | Warning |
TKT_LOGGED_DATE1 has a high cardinality: 45386 distinct values | Warning |
UNO_CS_COMM_COUNT is highly correlated with DELIVERY_STATUS (ρ = 0.9563908587) | Rejected |
UNO_CS_COMM_SYS is highly correlated with COMM_VINTAGE_SCORE (ρ = 0.9118394033) | Rejected |
UNO_EML_CAMPAIGN_RELATED_INFORMATION is highly skewed (γ1 = 29.60723533) | Skewed |
UNO_EML_CAMPAIGN_RELATED_INFORMATION has 51588 (99.7%) zeros | Zeros |
UNO_EML_OTHERS has 50185 (97.0%) zeros | Zeros |
UNO_EML_POLICY_SERVICING_-_CLARIFICATION/_FOLLOW_UP has 51406 (99.4%) zeros | Zeros |
UNO_EML_POLICY_STATUS_-_ACTIVE_/_LAPSE has 51255 (99.1%) zeros | Zeros |
CLEAN_INTENT
Categorical
| Distinct count | 13 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| DUEDATE/AMOUNT | |
|---|---|
| ACCOUNTVALUE/SURRENDERVALUE | |
| POLICYSTATUS-ACTIVE/LAPSE | |
| Other values (10) |
| Value | Count | Frequency (%) | |
| DUEDATE/AMOUNT | 13055 | 25.2% | |
| ACCOUNTVALUE/SURRENDERVALUE | 7574 | 14.6% | |
| POLICYSTATUS-ACTIVE/LAPSE | 7338 | 14.2% | |
| PREMIUMPAYMENT/CHEQUERECEIVEDENQUIRY | 5434 | 10.5% | |
| ECS/CREDITCARDINQUIRY | 3486 | 6.7% | |
| PREMIUMRECEIPTREQUEST | 3437 | 6.6% | |
| PROBABLESURRENDER | 2643 | 5.1% | |
| POSREQUESTSTATUSREQUIRED | 2447 | 4.7% | |
| BONUSINQUIRY | 2019 | 3.9% | |
| POLICYPACKDISPATCHSTATUS/CLARIFICATION | 1503 | 2.9% | |
| Other values (3) | 2803 | 5.4% |
| Max length | 39 |
|---|---|
| Mean length | 22.52210132 |
| Min length | 11 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | True |
CLI_EDUCATION_CAT_01
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 32 |
| Value | Count | Frequency (%) | |
| 0 | 51707 | 99.9% | |
| 1 | 32 | 0.1% |
CLI_EDUCATION_CAT_02
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 8112 |
| Value | Count | Frequency (%) | |
| 0 | 43627 | 84.3% | |
| 1 | 8112 | 15.7% |
CLI_EDUCATION_CAT_03
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 33734 | 65.2% | |
| 1 | 18005 | 34.8% |
CLI_EDUCATION_CAT_04
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 41333 | 79.9% | |
| 1 | 10406 | 20.1% |
CLI_HNI_IND_L
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 5236 |
| Value | Count | Frequency (%) | |
| 0 | 46503 | 89.9% | |
| 1 | 5236 | 10.1% |
CLI_HNI_IND_N
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 1 | |
|---|---|
| 0 |
| Value | Count | Frequency (%) | |
| 1 | 27178 | 52.5% | |
| 0 | 24561 | 47.5% |
CLI_HNI_IND_Y
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 4141 |
| Value | Count | Frequency (%) | |
| 0 | 47598 | 92.0% | |
| 1 | 4141 | 8.0% |
CLI_OCCUPATION_CAT_01
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 1620 |
| Value | Count | Frequency (%) | |
| 0 | 50119 | 96.9% | |
| 1 | 1620 | 3.1% |
CLI_OCCUPATION_CAT_02
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 32353 | 62.5% | |
| 1 | 19386 | 37.5% |
CLI_OCCUPATION_CAT_03
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 625 |
| Value | Count | Frequency (%) | |
| 0 | 51114 | 98.8% | |
| 1 | 625 | 1.2% |
CLI_OCCUPATION_CAT_04
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 40249 | 77.8% | |
| 1 | 11490 | 22.2% |
CLI_OCCUPATION_CAT_05
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 317 |
| Value | Count | Frequency (%) | |
| 0 | 51422 | 99.4% | |
| 1 | 317 | 0.6% |
CLI_OCCUPATION_CAT_06
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 448 |
| Value | Count | Frequency (%) | |
| 0 | 51291 | 99.1% | |
| 1 | 448 | 0.9% |
CLI_OCCUPATION_CAT_07
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 121 |
| Value | Count | Frequency (%) | |
| 0 | 51618 | 99.8% | |
| 1 | 121 | 0.2% |
CLI_OCCUPATION_CAT_08
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 2548 |
| Value | Count | Frequency (%) | |
| 0 | 49191 | 95.1% | |
| 1 | 2548 | 4.9% |
CLI_SNGL_MLTPL_PLCYHLDR_FLG_MULTIPLE
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 40560 | 78.4% | |
| 1 | 11179 | 21.6% |
CLI_SNGL_MLTPL_PLCYHLDR_FLG_SINGLE
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 26363 | 51.0% | |
| 1 | 25376 | 49.0% |
COMM_TKT_DT
Categorical
| Distinct count | 449 |
|---|---|
| Unique (%) | 0.9% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 3/12/2018 00:00 | 92 |
| 3/13/2018 0:00 | 77 |
| Other values (446) |
| Value | Count | Frequency (%) | |
| 0 | 38343 | 74.1% | |
| 3/12/2018 00:00 | 92 | 0.2% | |
| 3/13/2018 0:00 | 77 | 0.1% | |
| 3/20/2018 0:00 | 74 | 0.1% | |
| 3/7/2018 00:00 | 73 | 0.1% | |
| 3/19/2019 0:00 | 70 | 0.1% | |
| 4/10/2018 00:00 | 65 | 0.1% | |
| 3/10/2018 00:00 | 65 | 0.1% | |
| 4/6/2018 00:00 | 62 | 0.1% | |
| 2/26/2018 0:00 | 61 | 0.1% | |
| Other values (439) | 12757 | 24.7% |
| Max length | 16 |
|---|---|
| Mean length | 4.441156574 |
| Min length | 1 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
COMM_VINTAGE_SCORE
Numeric
| Distinct count | 15 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 2.649645335 |
|---|---|
| Minimum | 0 |
| Maximum | 14 |
| Zeros (%) | 74.6% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 1 |
| 95-th percentile | 14 |
| Maximum | 14 |
| Range | 14 |
| Interquartile range | 1 |
Descriptive statistics
| Standard deviation | 4.916194571 |
|---|---|
| Coef of variation | 1.855416083 |
| Kurtosis | 0.4149175488 |
| Mean | 2.649645335 |
| MAD | 3.98343494 |
| Skewness | 1.478102715 |
| Sum | 137090 |
| Variance | 24.16896906 |
| Memory size | 404.3 KiB |
| Value | Count | Frequency (%) | |
| 0 | 38587 | 74.6% | |
| 14 | 3462 | 6.7% | |
| 13 | 2013 | 3.9% | |
| 12 | 1389 | 2.7% | |
| 11 | 1111 | 2.1% | |
| 10 | 912 | 1.8% | |
| 8 | 752 | 1.5% | |
| 9 | 722 | 1.4% | |
| 7 | 539 | 1.0% | |
| 6 | 429 | 0.8% | |
| Other values (5) | 1823 | 3.5% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 38587 | 74.6% | |
| 1 | 360 | 0.7% | |
| 2 | 329 | 0.6% | |
| 3 | 376 | 0.7% | |
| 4 | 353 | 0.7% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 14 | 3462 | 6.7% | |
| 13 | 2013 | 3.9% | |
| 12 | 1389 | 2.7% | |
| 11 | 1111 | 2.1% | |
| 10 | 912 | 1.8% |
DELIVERY_STATUS
Numeric
| Distinct count | 46 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.781692727 |
|---|---|
| Minimum | 0 |
| Maximum | 655 |
| Zeros (%) | 76.9% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 4 |
| Maximum | 655 |
| Range | 655 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 3.79676497 |
|---|---|
| Coef of variation | 4.857106686 |
| Kurtosis | 17115.31074 |
| Mean | 0.781692727 |
| MAD | 1.202446138 |
| Skewness | 102.1243294 |
| Sum | 40444 |
| Variance | 14.41542424 |
| Memory size | 404.3 KiB |
| Value | Count | Frequency (%) | |
| 0 | 39794 | 76.9% | |
| 1 | 4518 | 8.7% | |
| 2 | 2813 | 5.4% | |
| 3 | 1243 | 2.4% | |
| 4 | 1043 | 2.0% | |
| 6 | 473 | 0.9% | |
| 5 | 463 | 0.9% | |
| 8 | 267 | 0.5% | |
| 7 | 242 | 0.5% | |
| 9 | 162 | 0.3% | |
| Other values (36) | 721 | 1.4% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 39794 | 76.9% | |
| 1 | 4518 | 8.7% | |
| 2 | 2813 | 5.4% | |
| 3 | 1243 | 2.4% | |
| 4 | 1043 | 2.0% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 655 | 1 | < 0.1% | |
| 163 | 1 | < 0.1% | |
| 64 | 1 | < 0.1% | |
| 63 | 1 | < 0.1% | |
| 60 | 1 | < 0.1% |
DUE_DATE_PAID
Categorical
| Distinct count | 456 |
|---|---|
| Unique (%) | 0.9% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 2/28/2019 0:00 | 113 |
| 3/31/2018 0:00 | 96 |
| Other values (453) |
| Value | Count | Frequency (%) | |
| 0 | 40287 | 77.9% | |
| 2/28/2019 0:00 | 113 | 0.2% | |
| 3/31/2018 0:00 | 96 | 0.2% | |
| 2/28/2018 0:00 | 88 | 0.2% | |
| 6/30/2018 0:00 | 76 | 0.1% | |
| 9/30/2018 0:00 | 74 | 0.1% | |
| 3/30/2018 0:00 | 67 | 0.1% | |
| 3/28/2018 0:00 | 67 | 0.1% | |
| 12/31/2018 0:00 | 65 | 0.1% | |
| 12/30/2018 0:00 | 62 | 0.1% | |
| Other values (446) | 10744 | 20.8% |
| Max length | 16 |
|---|---|
| Mean length | 3.939832621 |
| Min length | 1 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
DUE_DATE_SYS
Numeric
| Distinct count | 8 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.2345812637 |
|---|---|
| Minimum | 0 |
| Maximum | 8 |
| Zeros (%) | 77.9% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 8 |
| Range | 8 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 0.4589931282 |
|---|---|
| Coef of variation | 1.956648716 |
| Kurtosis | 5.808244109 |
| Mean | 0.2345812637 |
| MAD | 0.3653172798 |
| Skewness | 1.956190933 |
| Sum | 12137 |
| Variance | 0.2106746918 |
| Memory size | 404.3 KiB |
| Value | Count | Frequency (%) | |
| 0 | 40287 | 77.9% | |
| 1 | 10842 | 21.0% | |
| 2 | 563 | 1.1% | |
| 3 | 29 | 0.1% | |
| 4 | 12 | < 0.1% | |
| 5 | 4 | < 0.1% | |
| 8 | 1 | < 0.1% | |
| 6 | 1 | < 0.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 40287 | 77.9% | |
| 1 | 10842 | 21.0% | |
| 2 | 563 | 1.1% | |
| 3 | 29 | 0.1% | |
| 4 | 12 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 8 | 1 | < 0.1% | |
| 6 | 1 | < 0.1% | |
| 5 | 4 | < 0.1% | |
| 4 | 12 | < 0.1% | |
| 3 | 29 | 0.1% |
DUE_STS_SYS
Highly correlated
This variable is highly correlated with DUE_DATE_SYS and should be ignored for analysis
| Correlation | 0.9585905194 |
|---|
DUE_VINTAGE_SCORE
Numeric
| Distinct count | 15 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1.847658439 |
|---|---|
| Minimum | 0 |
| Maximum | 14 |
| Zeros (%) | 78.9% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 13 |
| Maximum | 14 |
| Range | 14 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 4.055571979 |
|---|---|
| Coef of variation | 2.194979273 |
| Kurtosis | 2.544727691 |
| Mean | 1.847658439 |
| MAD | 2.936406052 |
| Skewness | 2.023690771 |
| Sum | 95596 |
| Variance | 16.44766407 |
| Memory size | 404.3 KiB |
| Value | Count | Frequency (%) | |
| 0 | 40833 | 78.9% | |
| 14 | 1574 | 3.0% | |
| 13 | 1224 | 2.4% | |
| 12 | 1023 | 2.0% | |
| 11 | 872 | 1.7% | |
| 10 | 786 | 1.5% | |
| 9 | 683 | 1.3% | |
| 7 | 653 | 1.3% | |
| 8 | 632 | 1.2% | |
| 6 | 618 | 1.2% | |
| Other values (5) | 2841 | 5.5% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 40833 | 78.9% | |
| 1 | 611 | 1.2% | |
| 2 | 538 | 1.0% | |
| 3 | 558 | 1.1% | |
| 4 | 593 | 1.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 14 | 1574 | 3.0% | |
| 13 | 1224 | 2.4% | |
| 12 | 1023 | 2.0% | |
| 11 | 872 | 1.7% | |
| 10 | 786 | 1.5% |
ECS_FLAG_No
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 32535 | 62.9% | |
| 1 | 19204 | 37.1% |
ECS_FLAG_Yes
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 34388 | 66.5% | |
| 1 | 17351 | 33.5% |
HELP_LINE_ACCOUNTVALUE/SURRENDERVALUE
Numeric
| Distinct count | 15 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.02524208044 |
|---|---|
| Minimum | 0 |
| Maximum | 14 |
| Zeros (%) | 98.3% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 14 |
| Range | 14 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 0.2881904392 |
|---|---|
| Coef of variation | 11.41706365 |
| Kurtosis | 998.7622888 |
| Mean | 0.02524208044 |
| MAD | 0.04961964927 |
| Skewness | 26.97999883 |
| Sum | 1306 |
| Variance | 0.08305372923 |
| Memory size | 404.3 KiB |
| Value | Count | Frequency (%) | |
| 0 | 50853 | 98.3% | |
| 1 | 732 | 1.4% | |
| 2 | 93 | 0.2% | |
| 3 | 18 | < 0.1% | |
| 4 | 9 | < 0.1% | |
| 5 | 8 | < 0.1% | |
| 10 | 6 | < 0.1% | |
| 14 | 3 | < 0.1% | |
| 12 | 3 | < 0.1% | |
| 9 | 3 | < 0.1% | |
| Other values (5) | 11 | < 0.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 50853 | 98.3% | |
| 1 | 732 | 1.4% | |
| 2 | 93 | 0.2% | |
| 3 | 18 | < 0.1% | |
| 4 | 9 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 14 | 3 | < 0.1% | |
| 13 | 2 | < 0.1% | |
| 12 | 3 | < 0.1% | |
| 11 | 1 | < 0.1% | |
| 10 | 6 | < 0.1% |
HELP_LINE_BONUSINQUIRY
Numeric
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.006938672955 |
|---|---|
| Minimum | 0 |
| Maximum | 4 |
| Zeros (%) | 99.4% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 4 |
| Range | 4 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 0.09576733813 |
|---|---|
| Coef of variation | 13.80196743 |
| Kurtosis | 369.1444831 |
| Mean | 0.006938672955 |
| MAD | 0.01379393002 |
| Skewness | 17.05750961 |
| Sum | 359 |
| Variance | 0.009171383053 |
| Memory size | 404.3 KiB |
| Value | Count | Frequency (%) | |
| 0 | 51428 | 99.4% | |
| 1 | 273 | 0.5% | |
| 2 | 29 | 0.1% | |
| 3 | 8 | < 0.1% | |
| 4 | 1 | < 0.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 51428 | 99.4% | |
| 1 | 273 | 0.5% | |
| 2 | 29 | 0.1% | |
| 3 | 8 | < 0.1% | |
| 4 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 4 | 1 | < 0.1% | |
| 3 | 8 | < 0.1% | |
| 2 | 29 | 0.1% | |
| 1 | 273 | 0.5% | |
| 0 | 51428 | 99.4% |
HELP_LINE_DUEDATE/AMOUNT
Numeric
| Distinct count | 8 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.05523879472 |
|---|---|
| Minimum | 0 |
| Maximum | 7 |
| Zeros (%) | 95.4% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 7 |
| Range | 7 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 0.2821272771 |
|---|---|
| Coef of variation | 5.107411892 |
| Kurtosis | 86.59379255 |
| Mean | 0.05523879472 |
| MAD | 0.1054105545 |
| Skewness | 7.432349426 |
| Sum | 2858 |
| Variance | 0.07959580047 |
| Memory size | 404.3 KiB |
| Value | Count | Frequency (%) | |
| 0 | 49366 | 95.4% | |
| 1 | 2021 | 3.9% | |
| 2 | 273 | 0.5% | |
| 3 | 49 | 0.1% | |
| 4 | 15 | < 0.1% | |
| 5 | 10 | < 0.1% | |
| 7 | 4 | < 0.1% | |
| 6 | 1 | < 0.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 49366 | 95.4% | |
| 1 | 2021 | 3.9% | |
| 2 | 273 | 0.5% | |
| 3 | 49 | 0.1% | |
| 4 | 15 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 7 | 4 | < 0.1% | |
| 6 | 1 | < 0.1% | |
| 5 | 10 | < 0.1% | |
| 4 | 15 | < 0.1% | |
| 3 | 49 | 0.1% |
HELP_LINE_ECS/CREDITCARDINQUIRY
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 621 |
| 2 | 67 |
| Value | Count | Frequency (%) | |
| 0 | 51040 | 98.6% | |
| 1 | 621 | 1.2% | |
| 2 | 67 | 0.1% | |
| 3 | 11 | < 0.1% |
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
HELP_LINE_LOANENQUIRY
Numeric
| Distinct count | 8 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.00423278378 |
|---|---|
| Minimum | 0 |
| Maximum | 9 |
| Zeros (%) | 99.7% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 9 |
| Range | 9 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 0.1006447402 |
|---|---|
| Coef of variation | 23.77743476 |
| Kurtosis | 2322.820256 |
| Mean | 0.00423278378 |
| MAD | 0.008442333431 |
| Skewness | 39.97374162 |
| Sum | 219 |
| Variance | 0.01012936372 |
| Memory size | 404.3 KiB |
| Value | Count | Frequency (%) | |
| 0 | 51597 | 99.7% | |
| 1 | 100 | 0.2% | |
| 2 | 26 | 0.1% | |
| 4 | 7 | < 0.1% | |
| 3 | 6 | < 0.1% | |
| 9 | 1 | < 0.1% | |
| 7 | 1 | < 0.1% | |
| 5 | 1 | < 0.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 51597 | 99.7% | |
| 1 | 100 | 0.2% | |
| 2 | 26 | 0.1% | |
| 3 | 6 | < 0.1% | |
| 4 | 7 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 9 | 1 | < 0.1% | |
| 7 | 1 | < 0.1% | |
| 5 | 1 | < 0.1% | |
| 4 | 7 | < 0.1% | |
| 3 | 6 | < 0.1% |
HELP_LINE_OTHERS
Numeric
| Distinct count | 9 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.05320937784 |
|---|---|
| Minimum | 0 |
| Maximum | 8 |
| Zeros (%) | 95.7% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 8 |
| Range | 8 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 0.2802847861 |
|---|---|
| Coef of variation | 5.267582472 |
| Kurtosis | 93.75495863 |
| Mean | 0.05320937784 |
| MAD | 0.1018052674 |
| Skewness | 7.665525559 |
| Sum | 2753 |
| Variance | 0.07855956131 |
| Memory size | 404.3 KiB |
| Value | Count | Frequency (%) | |
| 0 | 49496 | 95.7% | |
| 1 | 1862 | 3.6% | |
| 2 | 301 | 0.6% | |
| 3 | 53 | 0.1% | |
| 4 | 17 | < 0.1% | |
| 7 | 4 | < 0.1% | |
| 5 | 4 | < 0.1% | |
| 8 | 1 | < 0.1% | |
| 6 | 1 | < 0.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 49496 | 95.7% | |
| 1 | 1862 | 3.6% | |
| 2 | 301 | 0.6% | |
| 3 | 53 | 0.1% | |
| 4 | 17 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 8 | 1 | < 0.1% | |
| 7 | 4 | < 0.1% | |
| 6 | 1 | < 0.1% | |
| 5 | 4 | < 0.1% | |
| 4 | 17 | < 0.1% |
HELP_LINE_PAYMENTPROCEDURE/ONLINEPAYMENTPROCEDURE
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 203 |
| 2 | 8 |
| Value | Count | Frequency (%) | |
| 0 | 51528 | 99.6% | |
| 1 | 203 | 0.4% | |
| 2 | 8 | < 0.1% |
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
HELP_LINE_POLICYPACKDISPATCHSTATUS/CLARIFICATION
Numeric
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.008272289762 |
|---|---|
| Minimum | 0 |
| Maximum | 4 |
| Zeros (%) | 99.3% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 4 |
| Range | 4 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 0.1086234509 |
|---|---|
| Coef of variation | 13.13100169 |
| Kurtosis | 328.858875 |
| Mean | 0.008272289762 |
| MAD | 0.01643234026 |
| Skewness | 16.26993297 |
| Sum | 428 |
| Variance | 0.01179905408 |
| Memory size | 404.3 KiB |
| Value | Count | Frequency (%) | |
| 0 | 51388 | 99.3% | |
| 1 | 288 | 0.6% | |
| 2 | 51 | 0.1% | |
| 3 | 10 | < 0.1% | |
| 4 | 2 | < 0.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 51388 | 99.3% | |
| 1 | 288 | 0.6% | |
| 2 | 51 | 0.1% | |
| 3 | 10 | < 0.1% | |
| 4 | 2 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 4 | 2 | < 0.1% | |
| 3 | 10 | < 0.1% | |
| 2 | 51 | 0.1% | |
| 1 | 288 | 0.6% | |
| 0 | 51388 | 99.3% |
HELP_LINE_POLICYSTATUS-ACTIVE/LAPSE
Numeric
| Distinct count | 8 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.03523454261 |
|---|---|
| Minimum | 0 |
| Maximum | 16 |
| Zeros (%) | 97.3% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 16 |
| Range | 16 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 0.254943297 |
|---|---|
| Coef of variation | 7.235606825 |
| Kurtosis | 686.5694774 |
| Mean | 0.03523454261 |
| MAD | 0.0685663559 |
| Skewness | 16.90375184 |
| Sum | 1823 |
| Variance | 0.06499608467 |
| Memory size | 404.3 KiB |
| Value | Count | Frequency (%) | |
| 0 | 50342 | 97.3% | |
| 1 | 1112 | 2.1% | |
| 2 | 203 | 0.4% | |
| 3 | 61 | 0.1% | |
| 5 | 10 | < 0.1% | |
| 4 | 8 | < 0.1% | |
| 16 | 2 | < 0.1% | |
| 8 | 1 | < 0.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 50342 | 97.3% | |
| 1 | 1112 | 2.1% | |
| 2 | 203 | 0.4% | |
| 3 | 61 | 0.1% | |
| 4 | 8 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 16 | 2 | < 0.1% | |
| 8 | 1 | < 0.1% | |
| 5 | 10 | < 0.1% | |
| 4 | 8 | < 0.1% | |
| 3 | 61 | 0.1% |
HELP_LINE_POSREQUESTSTATUSREQUIRED
Numeric
| Distinct count | 9 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.02021685769 |
|---|---|
| Minimum | 0 |
| Maximum | 9 |
| Zeros (%) | 98.5% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 9 |
| Range | 9 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 0.1973407993 |
|---|---|
| Coef of variation | 9.761200396 |
| Kurtosis | 364.2934262 |
| Mean | 0.02021685769 |
| MAD | 0.03983821699 |
| Skewness | 15.63232313 |
| Sum | 1046 |
| Variance | 0.03894339106 |
| Memory size | 404.3 KiB |
| Value | Count | Frequency (%) | |
| 0 | 50977 | 98.5% | |
| 1 | 594 | 1.1% | |
| 2 | 100 | 0.2% | |
| 3 | 46 | 0.1% | |
| 5 | 8 | < 0.1% | |
| 4 | 8 | < 0.1% | |
| 7 | 3 | < 0.1% | |
| 6 | 2 | < 0.1% | |
| 9 | 1 | < 0.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 50977 | 98.5% | |
| 1 | 594 | 1.1% | |
| 2 | 100 | 0.2% | |
| 3 | 46 | 0.1% | |
| 4 | 8 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 9 | 1 | < 0.1% | |
| 7 | 3 | < 0.1% | |
| 6 | 2 | < 0.1% | |
| 5 | 8 | < 0.1% | |
| 4 | 8 | < 0.1% |
HELP_LINE_PREMIUMPAYMENT/CHEQUERECEIVEDENQUIRY
Numeric
| Distinct count | 6 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.02620846943 |
|---|---|
| Minimum | 0 |
| Maximum | 6 |
| Zeros (%) | 97.7% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 6 |
| Range | 6 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 0.1865464888 |
|---|---|
| Coef of variation | 7.117794088 |
| Kurtosis | 117.7451675 |
| Mean | 0.02620846943 |
| MAD | 0.05123059519 |
| Skewness | 9.204836731 |
| Sum | 1356 |
| Variance | 0.03479959247 |
| Memory size | 404.3 KiB |
| Value | Count | Frequency (%) | |
| 0 | 50568 | 97.7% | |
| 1 | 1027 | 2.0% | |
| 2 | 114 | 0.2% | |
| 3 | 21 | < 0.1% | |
| 4 | 8 | < 0.1% | |
| 6 | 1 | < 0.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 50568 | 97.7% | |
| 1 | 1027 | 2.0% | |
| 2 | 114 | 0.2% | |
| 3 | 21 | < 0.1% | |
| 4 | 8 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 6 | 1 | < 0.1% | |
| 4 | 8 | < 0.1% | |
| 3 | 21 | < 0.1% | |
| 2 | 114 | 0.2% | |
| 1 | 1027 | 2.0% |
HELP_LINE_PREMIUMRECEIPTREQUEST
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 274 |
| 2 | 21 |
| Value | Count | Frequency (%) | |
| 0 | 51442 | 99.4% | |
| 1 | 274 | 0.5% | |
| 2 | 21 | < 0.1% | |
| 3 | 2 | < 0.1% |
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
HELP_LINE_PROBABLESURRENDER
Numeric
| Distinct count | 6 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.005663039487 |
|---|---|
| Minimum | 0 |
| Maximum | 5 |
| Zeros (%) | 99.5% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 5 |
| Range | 5 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 0.08829400595 |
|---|---|
| Coef of variation | 15.591275 |
| Kurtosis | 780.2717963 |
| Mean | 0.005663039487 |
| MAD | 0.01126960072 |
| Skewness | 22.69337676 |
| Sum | 293 |
| Variance | 0.007795831486 |
| Memory size | 404.3 KiB |
| Value | Count | Frequency (%) | |
| 0 | 51481 | 99.5% | |
| 1 | 236 | 0.5% | |
| 2 | 15 | < 0.1% | |
| 3 | 3 | < 0.1% | |
| 5 | 2 | < 0.1% | |
| 4 | 2 | < 0.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 51481 | 99.5% | |
| 1 | 236 | 0.5% | |
| 2 | 15 | < 0.1% | |
| 3 | 3 | < 0.1% | |
| 4 | 2 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 5 | 2 | < 0.1% | |
| 4 | 2 | < 0.1% | |
| 3 | 3 | < 0.1% | |
| 2 | 15 | < 0.1% | |
| 1 | 236 | 0.5% |
HELP_LINE_STATUSOFTHEPROPOSAL
Numeric
| Distinct count | 9 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.007789095267 |
|---|---|
| Minimum | 0 |
| Maximum | 10 |
| Zeros (%) | 99.5% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 10 |
| Range | 10 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 0.1317345628 |
|---|---|
| Coef of variation | 16.91269117 |
| Kurtosis | 1621.614915 |
| Mean | 0.007789095267 |
| MAD | 0.01549328264 |
| Skewness | 31.94253099 |
| Sum | 403 |
| Variance | 0.01735399503 |
| Memory size | 404.3 KiB |
| Value | Count | Frequency (%) | |
| 0 | 51457 | 99.5% | |
| 1 | 213 | 0.4% | |
| 2 | 45 | 0.1% | |
| 3 | 13 | < 0.1% | |
| 4 | 6 | < 0.1% | |
| 5 | 2 | < 0.1% | |
| 10 | 1 | < 0.1% | |
| 9 | 1 | < 0.1% | |
| 8 | 1 | < 0.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 51457 | 99.5% | |
| 1 | 213 | 0.4% | |
| 2 | 45 | 0.1% | |
| 3 | 13 | < 0.1% | |
| 4 | 6 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 10 | 1 | < 0.1% | |
| 9 | 1 | < 0.1% | |
| 8 | 1 | < 0.1% | |
| 5 | 2 | < 0.1% | |
| 4 | 6 | < 0.1% |
HELP_LINE_SYS
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 8310 |
| Value | Count | Frequency (%) | |
| 0 | 43429 | 83.9% | |
| 1 | 8310 | 16.1% |
INCOME_BUK_01
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 38461 | 74.3% | |
| 1 | 13278 | 25.7% |
INCOME_BUK_02
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 38777 | 74.9% | |
| 1 | 12962 | 25.1% |
INCOME_BUK_03
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 6825 |
| Value | Count | Frequency (%) | |
| 0 | 44914 | 86.8% | |
| 1 | 6825 | 13.2% |
INCOME_BUK_04
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 2528 |
| Value | Count | Frequency (%) | |
| 0 | 49211 | 95.1% | |
| 1 | 2528 | 4.9% |
INCOME_BUK_05
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 962 |
| Value | Count | Frequency (%) | |
| 0 | 50777 | 98.1% | |
| 1 | 962 | 1.9% |
ind_surr
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 1361 |
| Value | Count | Frequency (%) | |
| 0 | 50378 | 97.4% | |
| 1 | 1361 | 2.6% |
IVR_ACCOUNT_VALUE/_SURRENDER_VALUE
Numeric
| Distinct count | 10 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.004735306055 |
|---|---|
| Minimum | 0 |
| Maximum | 16 |
| Zeros (%) | 99.7% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 16 |
| Range | 16 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 0.1376172043 |
|---|---|
| Coef of variation | 29.06194503 |
| Kurtosis | 5664.615304 |
| Mean | 0.004735306055 |
| MAD | 0.009445717868 |
| Skewness | 62.98743417 |
| Sum | 245 |
| Variance | 0.01893849492 |
| Memory size | 404.3 KiB |
| Value | Count | Frequency (%) | |
| 0 | 51603 | 99.7% | |
| 1 | 94 | 0.2% | |
| 2 | 24 | < 0.1% | |
| 5 | 5 | < 0.1% | |
| 4 | 5 | < 0.1% | |
| 3 | 3 | < 0.1% | |
| 7 | 2 | < 0.1% | |
| 16 | 1 | < 0.1% | |
| 13 | 1 | < 0.1% | |
| 6 | 1 | < 0.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 51603 | 99.7% | |
| 1 | 94 | 0.2% | |
| 2 | 24 | < 0.1% | |
| 3 | 3 | < 0.1% | |
| 4 | 5 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 16 | 1 | < 0.1% | |
| 13 | 1 | < 0.1% | |
| 7 | 2 | < 0.1% | |
| 6 | 1 | < 0.1% | |
| 5 | 5 | < 0.1% |
IVR_OTHERS
Numeric
| Distinct count | 9 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.01812945747 |
|---|---|
| Minimum | 0 |
| Maximum | 11 |
| Zeros (%) | 98.7% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 11 |
| Range | 11 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 0.1848046051 |
|---|---|
| Coef of variation | 10.19360924 |
| Kurtosis | 499.4467459 |
| Mean | 0.01812945747 |
| MAD | 0.03577465915 |
| Skewness | 17.16682339 |
| Sum | 938 |
| Variance | 0.03415274206 |
| Memory size | 404.3 KiB |
| Value | Count | Frequency (%) | |
| 0 | 51048 | 98.7% | |
| 1 | 534 | 1.0% | |
| 2 | 107 | 0.2% | |
| 3 | 29 | 0.1% | |
| 4 | 13 | < 0.1% | |
| 6 | 3 | < 0.1% | |
| 5 | 3 | < 0.1% | |
| 11 | 1 | < 0.1% | |
| 7 | 1 | < 0.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 51048 | 98.7% | |
| 1 | 534 | 1.0% | |
| 2 | 107 | 0.2% | |
| 3 | 29 | 0.1% | |
| 4 | 13 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 11 | 1 | < 0.1% | |
| 7 | 1 | < 0.1% | |
| 6 | 3 | < 0.1% | |
| 5 | 3 | < 0.1% | |
| 4 | 13 | < 0.1% |
IVR_POLICY_STATUS_-_ACTIVE_/_LAPSE
Numeric
| Distinct count | 10 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.01874794642 |
|---|---|
| Minimum | 0 |
| Maximum | 13 |
| Zeros (%) | 98.7% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 13 |
| Range | 13 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 0.21275091 |
|---|---|
| Coef of variation | 11.34795807 |
| Kurtosis | 889.0970947 |
| Mean | 0.01874794642 |
| MAD | 0.03701975683 |
| Skewness | 23.17915677 |
| Sum | 970 |
| Variance | 0.04526294971 |
| Memory size | 404.3 KiB |
| Value | Count | Frequency (%) | |
| 0 | 51082 | 98.7% | |
| 1 | 482 | 0.9% | |
| 2 | 118 | 0.2% | |
| 3 | 29 | 0.1% | |
| 4 | 10 | < 0.1% | |
| 5 | 7 | < 0.1% | |
| 6 | 5 | < 0.1% | |
| 11 | 3 | < 0.1% | |
| 7 | 2 | < 0.1% | |
| 13 | 1 | < 0.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 51082 | 98.7% | |
| 1 | 482 | 0.9% | |
| 2 | 118 | 0.2% | |
| 3 | 29 | 0.1% | |
| 4 | 10 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 13 | 1 | < 0.1% | |
| 11 | 3 | < 0.1% | |
| 7 | 2 | < 0.1% | |
| 6 | 5 | < 0.1% | |
| 5 | 7 | < 0.1% |
IVR_PREMIUM_RECEIPT_REQUEST
Numeric
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.00427143934 |
|---|---|
| Minimum | 0 |
| Maximum | 5 |
| Zeros (%) | 99.6% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 5 |
| Range | 5 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 0.07409641131 |
|---|---|
| Coef of variation | 17.34694219 |
| Kurtosis | 774.7164173 |
| Mean | 0.00427143934 |
| MAD | 0.008510351049 |
| Skewness | 22.87083409 |
| Sum | 221 |
| Variance | 0.005490278169 |
| Memory size | 404.3 KiB |
| Value | Count | Frequency (%) | |
| 0 | 51542 | 99.6% | |
| 1 | 178 | 0.3% | |
| 2 | 16 | < 0.1% | |
| 3 | 2 | < 0.1% | |
| 5 | 1 | < 0.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 51542 | 99.6% | |
| 1 | 178 | 0.3% | |
| 2 | 16 | < 0.1% | |
| 3 | 2 | < 0.1% | |
| 5 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 5 | 1 | < 0.1% | |
| 3 | 2 | < 0.1% | |
| 2 | 16 | < 0.1% | |
| 1 | 178 | 0.3% | |
| 0 | 51542 | 99.6% |
IVR_SYS
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 1567 |
| Value | Count | Frequency (%) | |
| 0 | 50172 | 97.0% | |
| 1 | 1567 | 3.0% |
Lock_in_ind
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 3366 |
| Value | Count | Frequency (%) | |
| 0 | 48373 | 93.5% | |
| 1 | 3366 | 6.5% |
mapped_pol_id
Categorical
| Distinct count | 48127 |
|---|---|
| Unique (%) | 93.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| DKVMAEVMYSAEAEVMWL | 18 |
|---|---|
| ZTOOCGVMWLOOWLZTOO | 14 |
| WLOOWLDKZTVMOOBFZT | 10 |
| Other values (48124) |
| Value | Count | Frequency (%) | |
| DKVMAEVMYSAEAEVMWL | 18 | < 0.1% | |
| ZTOOCGVMWLOOWLZTOO | 14 | < 0.1% | |
| WLOOWLDKZTVMOOBFZT | 10 | < 0.1% | |
| WLOOZTDKOOAEDKWLWL | 9 | < 0.1% | |
| XRAEOOAECGXRAEOOZT | 8 | < 0.1% | |
| ZTAEZTZTCGOOOOYSBF | 7 | < 0.1% | |
| BFCGXRWLOOBFWLBFDK | 7 | < 0.1% | |
| DKOOVMOOZTWLXRYSAE | 6 | < 0.1% | |
| DKAEDKOOOOVMBFBFVM | 6 | < 0.1% | |
| DKWLWLZTAEOODKBFOO | 6 | < 0.1% | |
| Other values (48117) | 51648 | 99.8% |
| Max length | 18 |
|---|---|
| Mean length | 18 |
| Min length | 18 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
MEGA_MEGA_OTHERS
Numeric
| Distinct count | 7 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.01206053461 |
|---|---|
| Minimum | 0 |
| Maximum | 13 |
| Zeros (%) | 98.9% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 13 |
| Range | 13 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 0.1373806523 |
|---|---|
| Coef of variation | 11.39092559 |
| Kurtosis | 2736.516096 |
| Mean | 0.01206053461 |
| MAD | 0.02385439897 |
| Skewness | 35.4290705 |
| Sum | 624 |
| Variance | 0.01887344363 |
| Memory size | 404.3 KiB |
| Value | Count | Frequency (%) | |
| 0 | 51167 | 98.9% | |
| 1 | 547 | 1.1% | |
| 2 | 18 | < 0.1% | |
| 3 | 4 | < 0.1% | |
| 13 | 1 | < 0.1% | |
| 12 | 1 | < 0.1% | |
| 4 | 1 | < 0.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 51167 | 98.9% | |
| 1 | 547 | 1.1% | |
| 2 | 18 | < 0.1% | |
| 3 | 4 | < 0.1% | |
| 4 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 13 | 1 | < 0.1% | |
| 12 | 1 | < 0.1% | |
| 4 | 1 | < 0.1% | |
| 3 | 4 | < 0.1% | |
| 2 | 18 | < 0.1% |
MEGA_SCP_MG_1
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 607 |
| 2 | 25 |
| Value | Count | Frequency (%) | |
| 0 | 51106 | 98.8% | |
| 1 | 607 | 1.2% | |
| 2 | 25 | < 0.1% | |
| 3 | 1 | < 0.1% |
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
MEGA_SCP_MG_10
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 47 |
| Value | Count | Frequency (%) | |
| 0 | 51692 | 99.9% | |
| 1 | 47 | 0.1% |
MEGA_SCP_MG_11
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 7 |
| 2 | 5 |
| Value | Count | Frequency (%) | |
| 0 | 51727 | > 99.9% | |
| 1 | 7 | < 0.1% | |
| 2 | 5 | < 0.1% |
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
MEGA_SCP_MG_12
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 41 |
| Value | Count | Frequency (%) | |
| 0 | 51698 | 99.9% | |
| 1 | 41 | 0.1% |
MEGA_SCP_MG_13
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 16 |
| 2 | 4 |
| Value | Count | Frequency (%) | |
| 0 | 51719 | > 99.9% | |
| 1 | 16 | < 0.1% | |
| 2 | 4 | < 0.1% |
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
MEGA_SCP_MG_14
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 50 |
| 2 | 5 |
| Value | Count | Frequency (%) | |
| 0 | 51684 | 99.9% | |
| 1 | 50 | 0.1% | |
| 2 | 5 | < 0.1% |
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
MEGA_SCP_MG_2
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 464 |
| 2 | 45 |
| Value | Count | Frequency (%) | |
| 0 | 51229 | 99.0% | |
| 1 | 464 | 0.9% | |
| 2 | 45 | 0.1% | |
| 3 | 1 | < 0.1% |
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
MEGA_SCP_MG_3
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 168 |
| 2 | 13 |
| Value | Count | Frequency (%) | |
| 0 | 51557 | 99.6% | |
| 1 | 168 | 0.3% | |
| 2 | 13 | < 0.1% | |
| 3 | 1 | < 0.1% |
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
MEGA_SCP_MG_4
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 93 |
| Value | Count | Frequency (%) | |
| 0 | 51646 | 99.8% | |
| 1 | 93 | 0.2% |
MEGA_SCP_MG_5
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 174 |
| 2 | 13 |
| Value | Count | Frequency (%) | |
| 0 | 51552 | 99.6% | |
| 1 | 174 | 0.3% | |
| 2 | 13 | < 0.1% |
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
MEGA_SCP_MG_6
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 157 |
| 2 | 3 |
| Value | Count | Frequency (%) | |
| 0 | 51579 | 99.7% | |
| 1 | 157 | 0.3% | |
| 2 | 3 | < 0.1% |
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
MEGA_SCP_MG_7
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 79 |
| 2 | 19 |
| Value | Count | Frequency (%) | |
| 0 | 51640 | 99.8% | |
| 1 | 79 | 0.2% | |
| 2 | 19 | < 0.1% | |
| 3 | 1 | < 0.1% |
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
MEGA_SCP_MG_9
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 44 |
| 2 | 1 |
| Value | Count | Frequency (%) | |
| 0 | 51694 | 99.9% | |
| 1 | 44 | 0.1% | |
| 2 | 1 | < 0.1% |
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
MEGA_SYS
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 2339 |
| Value | Count | Frequency (%) | |
| 0 | 49400 | 95.5% | |
| 1 | 2339 | 4.5% |
MON_BNC_CHQ_VINTAGE_SCORE
Numeric
| Distinct count | 16 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.8861787047 |
|---|---|
| Minimum | 0 |
| Maximum | 15 |
| Zeros (%) | 90.5% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 10 |
| Maximum | 15 |
| Range | 15 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 3.031751473 |
|---|---|
| Coef of variation | 3.421151352 |
| Kurtosis | 10.77210086 |
| Mean | 0.8861787047 |
| MAD | 1.604470058 |
| Skewness | 3.461894393 |
| Sum | 45850 |
| Variance | 9.191516997 |
| Memory size | 404.3 KiB |
| Value | Count | Frequency (%) | |
| 0 | 46838 | 90.5% | |
| 13 | 617 | 1.2% | |
| 15 | 479 | 0.9% | |
| 12 | 477 | 0.9% | |
| 11 | 402 | 0.8% | |
| 14 | 384 | 0.7% | |
| 8 | 350 | 0.7% | |
| 10 | 336 | 0.6% | |
| 9 | 279 | 0.5% | |
| 7 | 257 | 0.5% | |
| Other values (6) | 1320 | 2.6% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 46838 | 90.5% | |
| 1 | 232 | 0.4% | |
| 2 | 200 | 0.4% | |
| 3 | 218 | 0.4% | |
| 4 | 214 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 15 | 479 | 0.9% | |
| 14 | 384 | 0.7% | |
| 13 | 617 | 1.2% | |
| 12 | 477 | 0.9% | |
| 11 | 402 | 0.8% |
MON_BOUNCE_COUNT
Numeric
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.111656584 |
|---|---|
| Minimum | 0 |
| Maximum | 4 |
| Zeros (%) | 90.2% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 4 |
| Range | 4 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 0.3567834685 |
|---|---|
| Coef of variation | 3.195364355 |
| Kurtosis | 12.6675874 |
| Mean | 0.111656584 |
| MAD | 0.2013698729 |
| Skewness | 3.434898072 |
| Sum | 5777 |
| Variance | 0.1272944434 |
| Memory size | 404.3 KiB |
| Value | Count | Frequency (%) | |
| 0 | 46655 | 90.2% | |
| 1 | 4424 | 8.6% | |
| 2 | 628 | 1.2% | |
| 3 | 31 | 0.1% | |
| 4 | 1 | < 0.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 46655 | 90.2% | |
| 1 | 4424 | 8.6% | |
| 2 | 628 | 1.2% | |
| 3 | 31 | 0.1% | |
| 4 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 4 | 1 | < 0.1% | |
| 3 | 31 | 0.1% | |
| 2 | 628 | 1.2% | |
| 1 | 4424 | 8.6% | |
| 0 | 46655 | 90.2% |
MON_CLEARANCE_COUNT
Numeric
| Distinct count | 7 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.2260577128 |
|---|---|
| Minimum | 0 |
| Maximum | 52 |
| Zeros (%) | 78.6% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 52 |
| Range | 52 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 0.5031123703 |
|---|---|
| Coef of variation | 2.225592589 |
| Kurtosis | 2186.596575 |
| Mean | 0.2260577128 |
| MAD | 0.3553640002 |
| Skewness | 22.83197841 |
| Sum | 11696 |
| Variance | 0.2531220571 |
| Memory size | 404.3 KiB |
| Value | Count | Frequency (%) | |
| 0 | 40667 | 78.6% | |
| 1 | 10528 | 20.3% | |
| 2 | 528 | 1.0% | |
| 3 | 12 | < 0.1% | |
| 4 | 2 | < 0.1% | |
| 52 | 1 | < 0.1% | |
| 16 | 1 | < 0.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 40667 | 78.6% | |
| 1 | 10528 | 20.3% | |
| 2 | 528 | 1.0% | |
| 3 | 12 | < 0.1% | |
| 4 | 2 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 52 | 1 | < 0.1% | |
| 16 | 1 | < 0.1% | |
| 4 | 2 | < 0.1% | |
| 3 | 12 | < 0.1% | |
| 2 | 528 | 1.0% |
MON_CLR_CHQ_VINTAGE_SCORE
Numeric
| Distinct count | 16 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 2.028276542 |
|---|---|
| Minimum | 0 |
| Maximum | 15 |
| Zeros (%) | 79.4% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 14 |
| Maximum | 15 |
| Range | 15 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 4.478501119 |
|---|---|
| Coef of variation | 2.208032794 |
| Kurtosis | 2.478873025 |
| Mean | 2.028276542 |
| MAD | 3.239452674 |
| Skewness | 2.018256431 |
| Sum | 104941 |
| Variance | 20.05697227 |
| Memory size | 404.3 KiB |
| Value | Count | Frequency (%) | |
| 0 | 41055 | 79.4% | |
| 15 | 2133 | 4.1% | |
| 14 | 1156 | 2.2% | |
| 13 | 889 | 1.7% | |
| 12 | 760 | 1.5% | |
| 8 | 668 | 1.3% | |
| 11 | 617 | 1.2% | |
| 10 | 559 | 1.1% | |
| 7 | 526 | 1.0% | |
| 5 | 513 | 1.0% | |
| Other values (6) | 2863 | 5.5% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 41055 | 79.4% | |
| 1 | 506 | 1.0% | |
| 2 | 418 | 0.8% | |
| 3 | 485 | 0.9% | |
| 4 | 464 | 0.9% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 15 | 2133 | 4.1% | |
| 14 | 1156 | 2.2% | |
| 13 | 889 | 1.7% | |
| 12 | 760 | 1.5% | |
| 11 | 617 | 1.2% |
MON_TKT_BOUNCE_DATE
Categorical
| Distinct count | 324 |
|---|---|
| Unique (%) | 0.6% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 3/12/2019 00:00 | 82 |
| 2/8/2018 00:00 | 77 |
| Other values (321) | 4925 |
| Value | Count | Frequency (%) | |
| 0 | 46655 | 90.2% | |
| 3/12/2019 00:00 | 82 | 0.2% | |
| 2/8/2018 00:00 | 77 | 0.1% | |
| 3/9/2018 00:00 | 72 | 0.1% | |
| 12/31/2018 0:00 | 67 | 0.1% | |
| 2/27/2019 0:00 | 65 | 0.1% | |
| 4/9/2018 00:00 | 65 | 0.1% | |
| 1/9/2018 00:00 | 64 | 0.1% | |
| 3/27/2018 0:00 | 57 | 0.1% | |
| 1/8/2019 00:00 | 56 | 0.1% | |
| Other values (314) | 4479 | 8.7% |
| Max length | 16 |
|---|---|
| Mean length | 2.307311699 |
| Min length | 1 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
MON_TKT_CLEARNACE_DATE
Categorical
| Distinct count | 367 |
|---|---|
| Unique (%) | 0.7% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 10/8/2018 00:00 | 93 |
| 2/8/2019 00:00 | 87 |
| Other values (364) |
| Value | Count | Frequency (%) | |
| 0 | 40667 | 78.6% | |
| 10/8/2018 00:00 | 93 | 0.2% | |
| 2/8/2019 00:00 | 87 | 0.2% | |
| 3/31/2018 0:00 | 81 | 0.2% | |
| 9/10/2018 00:00 | 76 | 0.1% | |
| 2/8/2018 00:00 | 76 | 0.1% | |
| 7/23/2018 0:00 | 72 | 0.1% | |
| 1/9/2018 00:00 | 71 | 0.1% | |
| 3/9/2018 00:00 | 71 | 0.1% | |
| 7/9/2018 00:00 | 70 | 0.1% | |
| Other values (357) | 10375 | 20.1% |
| Max length | 16 |
|---|---|
| Mean length | 3.844546667 |
| Min length | 1 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
MY_MON_BNC_SYS
Highly correlated
This variable is highly correlated with MON_BOUNCE_COUNT and should be ignored for analysis
| Correlation | 0.948047586 |
|---|
MY_MON_CLR_SYS
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 40667 | 78.6% | |
| 1 | 11072 | 21.4% |
new_policy
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 3128 |
| Value | Count | Frequency (%) | |
| 0 | 48611 | 94.0% | |
| 1 | 3128 | 6.0% |
PLAN_CAT_01
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 5127 |
| Value | Count | Frequency (%) | |
| 0 | 46612 | 90.1% | |
| 1 | 5127 | 9.9% |
PLAN_CAT_02
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 1147 |
| Value | Count | Frequency (%) | |
| 0 | 50592 | 97.8% | |
| 1 | 1147 | 2.2% |
PLAN_CAT_03
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 28542 | 55.2% | |
| 1 | 23197 | 44.8% |
PLAN_CAT_04
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 7084 |
| Value | Count | Frequency (%) | |
| 0 | 44655 | 86.3% | |
| 1 | 7084 | 13.7% |
PLAN_FAMILY_01
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 39474 | 76.3% | |
| 1 | 12265 | 23.7% |
PLAN_FAMILY_02
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 1499 |
| Value | Count | Frequency (%) | |
| 0 | 50240 | 97.1% | |
| 1 | 1499 | 2.9% |
PLAN_FAMILY_03
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 3194 |
| Value | Count | Frequency (%) | |
| 0 | 48545 | 93.8% | |
| 1 | 3194 | 6.2% |
PLAN_FAMILY_04
Highly correlated
This variable is highly correlated with PLAN_CAT_02 and should be ignored for analysis
| Correlation | 0.9697120372 |
|---|
PLAN_FAMILY_05
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 1456 |
| Value | Count | Frequency (%) | |
| 0 | 50283 | 97.2% | |
| 1 | 1456 | 2.8% |
PLAN_FAMILY_06
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 1109 |
| Value | Count | Frequency (%) | |
| 0 | 50630 | 97.9% | |
| 1 | 1109 | 2.1% |
PLAN_FAMILY_07
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 3334 |
| Value | Count | Frequency (%) | |
| 0 | 48405 | 93.6% | |
| 1 | 3334 | 6.4% |
PLAN_FAMILY_08
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 499 |
| Value | Count | Frequency (%) | |
| 0 | 51240 | 99.0% | |
| 1 | 499 | 1.0% |
PLAN_FAMILY_09
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 4191 |
| Value | Count | Frequency (%) | |
| 0 | 47548 | 91.9% | |
| 1 | 4191 | 8.1% |
PLAN_FAMILY_10
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 104 |
| Value | Count | Frequency (%) | |
| 0 | 51635 | 99.8% | |
| 1 | 104 | 0.2% |
PLAN_FAMILY_11
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 145 |
| Value | Count | Frequency (%) | |
| 0 | 51594 | 99.7% | |
| 1 | 145 | 0.3% |
PLAN_FAMILY_12
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 222 |
| Value | Count | Frequency (%) | |
| 0 | 51517 | 99.6% | |
| 1 | 222 | 0.4% |
PLAN_FAMILY_13
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 55 |
| Value | Count | Frequency (%) | |
| 0 | 51684 | 99.9% | |
| 1 | 55 | 0.1% |
PLAN_FAMILY_14
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 57 |
| Value | Count | Frequency (%) | |
| 0 | 51682 | 99.9% | |
| 1 | 57 | 0.1% |
PLAN_FAMILY_15
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 612 |
| Value | Count | Frequency (%) | |
| 0 | 51127 | 98.8% | |
| 1 | 612 | 1.2% |
PLAN_FAMILY_16
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 6733 |
| Value | Count | Frequency (%) | |
| 0 | 45006 | 87.0% | |
| 1 | 6733 | 13.0% |
PLAN_TYPE_01
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 30920 | 59.8% | |
| 1 | 20819 | 40.2% |
PLAN_TYPE_02
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 2579 |
| Value | Count | Frequency (%) | |
| 0 | 49160 | 95.0% | |
| 1 | 2579 | 5.0% |
PLAN_TYPE_03
Highly correlated
This variable is highly correlated with PLAN_CAT_01 and should be ignored for analysis
| Correlation | 1 |
|---|
PLAN_TYPE_04
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 2870 |
| Value | Count | Frequency (%) | |
| 0 | 48869 | 94.5% | |
| 1 | 2870 | 5.5% |
PLAN_TYPE_05
Highly correlated
This variable is highly correlated with PLAN_FAMILY_07 and should be ignored for analysis
| Correlation | 0.9173916105 |
|---|
PLAN_TYPE_06
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 1189 |
| Value | Count | Frequency (%) | |
| 0 | 50550 | 97.7% | |
| 1 | 1189 | 2.3% |
PLAN_TYPE_07
Highly correlated
This variable is highly correlated with PLAN_FAMILY_14 and should be ignored for analysis
| Correlation | 1 |
|---|
POL_COV_TERM
Numeric
| Distinct count | 94 |
|---|---|
| Unique (%) | 0.2% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 19.2259804 |
|---|---|
| Minimum | 0 |
| Maximum | 100 |
| Zeros (%) | 29.3% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 20 |
| Q3 | 25 |
| 95-th percentile | 62 |
| Maximum | 100 |
| Range | 100 |
| Interquartile range | 25 |
Descriptive statistics
| Standard deviation | 18.63247068 |
|---|---|
| Coef of variation | 0.9691298071 |
| Kurtosis | 1.699903182 |
| Mean | 19.2259804 |
| MAD | 13.30823946 |
| Skewness | 1.278426865 |
| Sum | 994733 |
| Variance | 347.1689636 |
| Memory size | 404.3 KiB |
| Value | Count | Frequency (%) | |
| 0 | 15185 | 29.3% | |
| 20 | 11751 | 22.7% | |
| 15 | 4609 | 8.9% | |
| 10 | 2427 | 4.7% | |
| 25 | 1735 | 3.4% | |
| 22 | 1435 | 2.8% | |
| 40 | 1405 | 2.7% | |
| 16 | 1324 | 2.6% | |
| 35 | 979 | 1.9% | |
| 30 | 697 | 1.3% | |
| Other values (84) | 10192 | 19.7% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 15185 | 29.3% | |
| 5 | 8 | < 0.1% | |
| 8 | 1 | < 0.1% | |
| 10 | 2427 | 4.7% | |
| 11 | 277 | 0.5% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 100 | 10 | < 0.1% | |
| 99 | 9 | < 0.1% | |
| 98 | 6 | < 0.1% | |
| 97 | 15 | < 0.1% | |
| 96 | 9 | < 0.1% |
POL_PPT
Numeric
| Distinct count | 15 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 264.1892576 |
|---|---|
| Minimum | 0 |
| Maximum | 999 |
| Zeros (%) | 29.3% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 10 |
| Q3 | 999 |
| 95-th percentile | 999 |
| Maximum | 999 |
| Range | 999 |
| Interquartile range | 999 |
Descriptive statistics
| Standard deviation | 435.4332141 |
|---|---|
| Coef of variation | 1.648186675 |
| Kurtosis | -0.8009575582 |
| Mean | 264.1892576 |
| MAD | 381.8703732 |
| Skewness | 1.094516882 |
| Sum | 13668888 |
| Variance | 189602.084 |
| Memory size | 404.3 KiB |
| Value | Count | Frequency (%) | |
| 0 | 15184 | 29.3% | |
| 999 | 13444 | 26.0% | |
| 10 | 7349 | 14.2% | |
| 6 | 5636 | 10.9% | |
| 12 | 2058 | 4.0% | |
| 8 | 1991 | 3.8% | |
| 20 | 1714 | 3.3% | |
| 5 | 1586 | 3.1% | |
| 15 | 1048 | 2.0% | |
| 7 | 701 | 1.4% | |
| Other values (5) | 1028 | 2.0% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 15184 | 29.3% | |
| 1 | 140 | 0.3% | |
| 3 | 18 | < 0.1% | |
| 5 | 1586 | 3.1% | |
| 6 | 5636 | 10.9% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 999 | 13444 | 26.0% | |
| 60 | 341 | 0.7% | |
| 20 | 1714 | 3.3% | |
| 18 | 156 | 0.3% | |
| 15 | 1048 | 2.0% |
POL_RIDER_COUNT
Numeric
| Distinct count | 25 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.6829664276 |
|---|---|
| Minimum | 0 |
| Maximum | 31 |
| Zeros (%) | 62.0% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 1 |
| 95-th percentile | 3 |
| Maximum | 31 |
| Range | 31 |
| Interquartile range | 1 |
Descriptive statistics
| Standard deviation | 1.227816008 |
|---|---|
| Coef of variation | 1.797769199 |
| Kurtosis | 67.30159999 |
| Mean | 0.6829664276 |
| MAD | 0.8472432245 |
| Skewness | 5.248500953 |
| Sum | 35336 |
| Variance | 1.507532149 |
| Memory size | 404.3 KiB |
| Value | Count | Frequency (%) | |
| 0 | 32092 | 62.0% | |
| 1 | 10199 | 19.7% | |
| 2 | 6170 | 11.9% | |
| 3 | 1947 | 3.8% | |
| 4 | 998 | 1.9% | |
| 6 | 133 | 0.3% | |
| 8 | 62 | 0.1% | |
| 5 | 27 | 0.1% | |
| 9 | 14 | < 0.1% | |
| 7 | 14 | < 0.1% | |
| Other values (15) | 83 | 0.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 32092 | 62.0% | |
| 1 | 10199 | 19.7% | |
| 2 | 6170 | 11.9% | |
| 3 | 1947 | 3.8% | |
| 4 | 998 | 1.9% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 31 | 2 | < 0.1% | |
| 27 | 1 | < 0.1% | |
| 26 | 2 | < 0.1% | |
| 24 | 5 | < 0.1% | |
| 22 | 2 | < 0.1% |
POLICY_CHNL_01
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 39108 | 75.6% | |
| 1 | 12631 | 24.4% |
POLICY_CHNL_02
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 38721 | 74.8% | |
| 1 | 13018 | 25.2% |
POLICY_CHNL_03
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 666 |
| Value | Count | Frequency (%) | |
| 0 | 51073 | 98.7% | |
| 1 | 666 | 1.3% |
POLICY_CHNL_04
Highly correlated
This variable is highly correlated with PLAN_TYPE_03 and should be ignored for analysis
| Correlation | 0.9023277115 |
|---|
POLICY_CHNL_05
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 4359 |
| Value | Count | Frequency (%) | |
| 0 | 47380 | 91.6% | |
| 1 | 4359 | 8.4% |
POLICY_CHNL_06
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 1507 |
| Value | Count | Frequency (%) | |
| 0 | 50232 | 97.1% | |
| 1 | 1507 | 2.9% |
POS_COUNT
Numeric
| Distinct count | 14 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.1410541371 |
|---|---|
| Minimum | 0 |
| Maximum | 16 |
| Zeros (%) | 89.2% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 16 |
| Range | 16 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 0.4813300223 |
|---|---|
| Coef of variation | 3.412377915 |
| Kurtosis | 89.49223133 |
| Mean | 0.1410541371 |
| MAD | 0.2515141474 |
| Skewness | 6.387368416 |
| Sum | 7298 |
| Variance | 0.2316785903 |
| Memory size | 404.3 KiB |
| Value | Count | Frequency (%) | |
| 0 | 46128 | 89.2% | |
| 1 | 4487 | 8.7% | |
| 2 | 804 | 1.6% | |
| 3 | 198 | 0.4% | |
| 4 | 75 | 0.1% | |
| 5 | 22 | < 0.1% | |
| 6 | 11 | < 0.1% | |
| 8 | 4 | < 0.1% | |
| 7 | 4 | < 0.1% | |
| 9 | 2 | < 0.1% | |
| Other values (4) | 4 | < 0.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 46128 | 89.2% | |
| 1 | 4487 | 8.7% | |
| 2 | 804 | 1.6% | |
| 3 | 198 | 0.4% | |
| 4 | 75 | 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 16 | 1 | < 0.1% | |
| 15 | 1 | < 0.1% | |
| 13 | 1 | < 0.1% | |
| 11 | 1 | < 0.1% | |
| 9 | 2 | < 0.1% |
POS_SYS_TOUCH_PT
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 5611 |
| Value | Count | Frequency (%) | |
| 0 | 46128 | 89.2% | |
| 1 | 5611 | 10.8% |
POS_TKT_LOGGED_DATE1
Categorical
| Distinct count | 389 |
|---|---|
| Unique (%) | 0.8% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1/31/2018 0:00 | 55 |
| 11/20/2018 0:00 | 46 |
| Other values (386) | 5510 |
| Value | Count | Frequency (%) | |
| 0 | 46128 | 89.2% | |
| 1/31/2018 0:00 | 55 | 0.1% | |
| 11/20/2018 0:00 | 46 | 0.1% | |
| 2/15/2019 0:00 | 46 | 0.1% | |
| 8/28/2018 0:00 | 43 | 0.1% | |
| 3/12/2019 00:00 | 40 | 0.1% | |
| 2/14/2018 0:00 | 40 | 0.1% | |
| 9/28/2018 0:00 | 38 | 0.1% | |
| 8/21/2018 0:00 | 37 | 0.1% | |
| 2/26/2019 0:00 | 37 | 0.1% | |
| Other values (379) | 5229 | 10.1% |
| Max length | 16 |
|---|---|
| Mean length | 2.44049943 |
| Min length | 1 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
POS_VINTAGE_SCORE
Numeric
| Distinct count | 16 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1.103732194 |
|---|---|
| Minimum | 0 |
| Maximum | 15 |
| Zeros (%) | 89.5% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 12 |
| Maximum | 15 |
| Range | 15 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 3.523802501 |
|---|---|
| Coef of variation | 3.192624551 |
| Kurtosis | 8.451504601 |
| Mean | 1.103732194 |
| MAD | 1.976234505 |
| Skewness | 3.145960195 |
| Sum | 57106 |
| Variance | 12.41718407 |
| Memory size | 404.3 KiB |
| Value | Count | Frequency (%) | |
| 0 | 46302 | 89.5% | |
| 15 | 1521 | 2.9% | |
| 14 | 541 | 1.0% | |
| 13 | 360 | 0.7% | |
| 11 | 343 | 0.7% | |
| 10 | 338 | 0.7% | |
| 12 | 329 | 0.6% | |
| 8 | 311 | 0.6% | |
| 9 | 303 | 0.6% | |
| 7 | 229 | 0.4% | |
| Other values (6) | 1162 | 2.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 46302 | 89.5% | |
| 1 | 185 | 0.4% | |
| 2 | 205 | 0.4% | |
| 3 | 177 | 0.3% | |
| 4 | 181 | 0.3% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 15 | 1521 | 2.9% | |
| 14 | 541 | 1.0% | |
| 13 | 360 | 0.7% | |
| 12 | 329 | 0.6% | |
| 11 | 343 | 0.7% |
REN_COUNT
Numeric
| Distinct count | 18 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.3898606467 |
|---|---|
| Minimum | 0 |
| Maximum | 23 |
| Zeros (%) | 82.0% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 3 |
| Maximum | 23 |
| Range | 23 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 1.036213898 |
|---|---|
| Coef of variation | 2.657908426 |
| Kurtosis | 25.50924904 |
| Mean | 0.3898606467 |
| MAD | 0.6394019026 |
| Skewness | 3.956195466 |
| Sum | 20171 |
| Variance | 1.073739242 |
| Memory size | 404.3 KiB |
| Value | Count | Frequency (%) | |
| 0 | 42428 | 82.0% | |
| 1 | 3814 | 7.4% | |
| 2 | 2634 | 5.1% | |
| 3 | 1535 | 3.0% | |
| 4 | 745 | 1.4% | |
| 5 | 365 | 0.7% | |
| 6 | 93 | 0.2% | |
| 7 | 51 | 0.1% | |
| 8 | 19 | < 0.1% | |
| 9 | 15 | < 0.1% | |
| Other values (8) | 40 | 0.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 42428 | 82.0% | |
| 1 | 3814 | 7.4% | |
| 2 | 2634 | 5.1% | |
| 3 | 1535 | 3.0% | |
| 4 | 745 | 1.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 23 | 1 | < 0.1% | |
| 16 | 1 | < 0.1% | |
| 15 | 3 | < 0.1% | |
| 14 | 3 | < 0.1% | |
| 13 | 3 | < 0.1% |
REN_SYS_TOUCH_PT
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 42428 | 82.0% | |
| 1 | 9311 | 18.0% |
REN_TKT_LOGGED_DATE1
Categorical
| Distinct count | 390 |
|---|---|
| Unique (%) | 0.8% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 3/14/2019 0:00 | 82 |
| 3/20/2018 0:00 | 68 |
| Other values (387) |
| Value | Count | Frequency (%) | |
| 0 | 42428 | 82.0% | |
| 3/14/2019 0:00 | 82 | 0.2% | |
| 3/20/2018 0:00 | 68 | 0.1% | |
| 3/19/2018 0:00 | 53 | 0.1% | |
| 3/12/2018 00:00 | 51 | 0.1% | |
| 1/14/2019 0:00 | 50 | 0.1% | |
| 4/5/2018 00:00 | 49 | 0.1% | |
| 3/18/2018 0:00 | 49 | 0.1% | |
| 12/28/2018 0:00 | 48 | 0.1% | |
| 1/9/2018 00:00 | 48 | 0.1% | |
| Other values (380) | 8813 | 17.0% |
| Max length | 16 |
|---|---|
| Mean length | 3.384100968 |
| Min length | 1 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
REN_VINTAGE_SCORE
Highly correlated
This variable is highly correlated with REN_SYS_TOUCH_PT and should be ignored for analysis
| Correlation | 0.9115846582 |
|---|
SCP_EML_SCP_EM_1
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 3534 |
| 2 | 315 |
| Value | Count | Frequency (%) | |
| 0 | 47870 | 92.5% | |
| 1 | 3534 | 6.8% | |
| 2 | 315 | 0.6% | |
| 3 | 20 | < 0.1% |
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
SCP_EML_SCP_EM_10
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 305 |
| 2 | 10 |
| Value | Count | Frequency (%) | |
| 0 | 51424 | 99.4% | |
| 1 | 305 | 0.6% | |
| 2 | 10 | < 0.1% |
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
SCP_EML_SCP_EM_13
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 780 |
| 2 | 2 |
| Value | Count | Frequency (%) | |
| 0 | 50957 | 98.5% | |
| 1 | 780 | 1.5% | |
| 2 | 2 | < 0.1% |
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
SCP_EML_SCP_EM_14
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 124 |
| 2 | 4 |
| Value | Count | Frequency (%) | |
| 0 | 51611 | 99.8% | |
| 1 | 124 | 0.2% | |
| 2 | 4 | < 0.1% |
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
SCP_EML_SCP_EM_15
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 158 |
| Value | Count | Frequency (%) | |
| 0 | 51581 | 99.7% | |
| 1 | 158 | 0.3% |
SCP_EML_SCP_EM_16
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 121 |
| 2 | 1 |
| Value | Count | Frequency (%) | |
| 0 | 51617 | 99.8% | |
| 1 | 121 | 0.2% | |
| 2 | 1 | < 0.1% |
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
SCP_EML_SCP_EM_17
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 122 |
| Value | Count | Frequency (%) | |
| 0 | 51617 | 99.8% | |
| 1 | 122 | 0.2% |
SCP_EML_SCP_EM_18
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 446 |
| 2 | 10 |
| Value | Count | Frequency (%) | |
| 0 | 51283 | 99.1% | |
| 1 | 446 | 0.9% | |
| 2 | 10 | < 0.1% |
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
SCP_EML_SCP_EM_19
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 645 |
| 2 | 64 |
| Value | Count | Frequency (%) | |
| 0 | 51028 | 98.6% | |
| 1 | 645 | 1.2% | |
| 2 | 64 | 0.1% | |
| 3 | 2 | < 0.1% |
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
SCP_EML_SCP_EM_2
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 3586 |
| 2 | 102 |
| Value | Count | Frequency (%) | |
| 0 | 48051 | 92.9% | |
| 1 | 3586 | 6.9% | |
| 2 | 102 | 0.2% |
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
SCP_EML_SCP_EM_3
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 2059 |
| 2 | 106 |
| Value | Count | Frequency (%) | |
| 0 | 49573 | 95.8% | |
| 1 | 2059 | 4.0% | |
| 2 | 106 | 0.2% | |
| 3 | 1 | < 0.1% |
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
SCP_EML_SCP_EM_4
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 916 |
| 2 | 54 |
| Value | Count | Frequency (%) | |
| 0 | 50769 | 98.1% | |
| 1 | 916 | 1.8% | |
| 2 | 54 | 0.1% |
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
SCP_EML_SCP_EM_5
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 816 |
| 2 | 39 |
| Value | Count | Frequency (%) | |
| 0 | 50880 | 98.3% | |
| 1 | 816 | 1.6% | |
| 2 | 39 | 0.1% | |
| 3 | 4 | < 0.1% |
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
SCP_EML_SCP_EM_6
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 1045 |
| 2 | 36 |
| Value | Count | Frequency (%) | |
| 0 | 50658 | 97.9% | |
| 1 | 1045 | 2.0% | |
| 2 | 36 | 0.1% |
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
SCP_EML_SCP_EM_7
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 505 |
| 2 | 2 |
| Value | Count | Frequency (%) | |
| 0 | 51232 | 99.0% | |
| 1 | 505 | 1.0% | |
| 2 | 2 | < 0.1% |
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
SCP_EML_SCP_EM_8
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 934 |
| 2 | 29 |
| Value | Count | Frequency (%) | |
| 0 | 50776 | 98.1% | |
| 1 | 934 | 1.8% | |
| 2 | 29 | 0.1% |
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
SCP_EML_SCP_EM_9
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 497 |
| 2 | 18 |
| Value | Count | Frequency (%) | |
| 0 | 51223 | 99.0% | |
| 1 | 497 | 1.0% | |
| 2 | 18 | < 0.1% | |
| 3 | 1 | < 0.1% |
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
SCP_EML_SCP_EML_OTHERS
Numeric
| Distinct count | 6 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.140976826 |
|---|---|
| Minimum | 0 |
| Maximum | 5 |
| Zeros (%) | 88.3% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 5 |
| Range | 5 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 0.4237369904 |
|---|---|
| Coef of variation | 3.005720887 |
| Kurtosis | 17.64244909 |
| Mean | 0.140976826 |
| MAD | 0.2488695062 |
| Skewness | 3.680699936 |
| Sum | 7294 |
| Variance | 0.1795530371 |
| Memory size | 404.3 KiB |
| Value | Count | Frequency (%) | |
| 0 | 45668 | 88.3% | |
| 1 | 5070 | 9.8% | |
| 2 | 836 | 1.6% | |
| 3 | 118 | 0.2% | |
| 4 | 37 | 0.1% | |
| 5 | 10 | < 0.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 45668 | 88.3% | |
| 1 | 5070 | 9.8% | |
| 2 | 836 | 1.6% | |
| 3 | 118 | 0.2% | |
| 4 | 37 | 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 5 | 10 | < 0.1% | |
| 4 | 37 | 0.1% | |
| 3 | 118 | 0.2% | |
| 2 | 836 | 1.6% | |
| 1 | 5070 | 9.8% |
SCP_EML_SYS
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 35652 | 68.9% | |
| 1 | 16087 | 31.1% |
SCP_SMS_AGENT_-_OTHER
Numeric
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.002802528074 |
|---|---|
| Minimum | 0 |
| Maximum | 4 |
| Zeros (%) | 99.9% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 4 |
| Range | 4 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 0.07622283027 |
|---|---|
| Coef of variation | 27.19788286 |
| Kurtosis | 914.1436162 |
| Mean | 0.002802528074 |
| MAD | 0.005597039484 |
| Skewness | 29.00202748 |
| Sum | 145 |
| Variance | 0.005809919854 |
| Memory size | 404.3 KiB |
| Value | Count | Frequency (%) | |
| 0 | 51665 | 99.9% | |
| 2 | 63 | 0.1% | |
| 1 | 8 | < 0.1% | |
| 4 | 2 | < 0.1% | |
| 3 | 1 | < 0.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 51665 | 99.9% | |
| 1 | 8 | < 0.1% | |
| 2 | 63 | 0.1% | |
| 3 | 1 | < 0.1% | |
| 4 | 2 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 4 | 2 | < 0.1% | |
| 3 | 1 | < 0.1% | |
| 2 | 63 | 0.1% | |
| 1 | 8 | < 0.1% | |
| 0 | 51665 | 99.9% |
SCP_SMS_CUSTOMER_AWARENESS
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 320 |
| 2 | 13 |
| Value | Count | Frequency (%) | |
| 0 | 51406 | 99.4% | |
| 1 | 320 | 0.6% | |
| 2 | 13 | < 0.1% |
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
SCP_SMS_LAPSATION_&_REVIVAL
Numeric
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.02141518004 |
|---|---|
| Minimum | 0 |
| Maximum | 4 |
| Zeros (%) | 98.0% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 4 |
| Range | 4 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 0.1516764959 |
|---|---|
| Coef of variation | 7.082662655 |
| Kurtosis | 67.58384427 |
| Mean | 0.02141518004 |
| MAD | 0.04195370318 |
| Skewness | 7.638771988 |
| Sum | 1108 |
| Variance | 0.02300575941 |
| Memory size | 404.3 KiB |
| Value | Count | Frequency (%) | |
| 0 | 50680 | 98.0% | |
| 1 | 1013 | 2.0% | |
| 2 | 44 | 0.1% | |
| 4 | 1 | < 0.1% | |
| 3 | 1 | < 0.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 50680 | 98.0% | |
| 1 | 1013 | 2.0% | |
| 2 | 44 | 0.1% | |
| 3 | 1 | < 0.1% | |
| 4 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 4 | 1 | < 0.1% | |
| 3 | 1 | < 0.1% | |
| 2 | 44 | 0.1% | |
| 1 | 1013 | 2.0% | |
| 0 | 50680 | 98.0% |
SCP_SMS_MOBILE_NUMBER_LINK
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 52 |
| Value | Count | Frequency (%) | |
| 0 | 51687 | 99.9% | |
| 1 | 52 | 0.1% |
SCP_SMS_PAYMENT
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 43 |
| 2 | 1 |
| Value | Count | Frequency (%) | |
| 0 | 51695 | 99.9% | |
| 1 | 43 | 0.1% | |
| 2 | 1 | < 0.1% |
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
SCP_SMS_PAYMENT_MODE
Numeric
| Distinct count | 10 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.1664894954 |
|---|---|
| Minimum | 0 |
| Maximum | 12 |
| Zeros (%) | 88.9% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 12 |
| Range | 12 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 0.6491751232 |
|---|---|
| Coef of variation | 3.899195693 |
| Kurtosis | 94.3362241 |
| Mean | 0.1664894954 |
| MAD | 0.2959734592 |
| Skewness | 8.052499865 |
| Sum | 8614 |
| Variance | 0.4214283406 |
| Memory size | 404.3 KiB |
| Value | Count | Frequency (%) | |
| 0 | 45989 | 88.9% | |
| 1 | 4345 | 8.4% | |
| 2 | 991 | 1.9% | |
| 4 | 149 | 0.3% | |
| 6 | 73 | 0.1% | |
| 8 | 71 | 0.1% | |
| 3 | 71 | 0.1% | |
| 10 | 29 | 0.1% | |
| 12 | 11 | < 0.1% | |
| 5 | 10 | < 0.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 45989 | 88.9% | |
| 1 | 4345 | 8.4% | |
| 2 | 991 | 1.9% | |
| 3 | 71 | 0.1% | |
| 4 | 149 | 0.3% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 12 | 11 | < 0.1% | |
| 10 | 29 | 0.1% | |
| 8 | 71 | 0.1% | |
| 6 | 73 | 0.1% | |
| 5 | 10 | < 0.1% |
SCP_SMS_POS
Constant
This variable is constant and should be ignored for analysis
| Constant value | 0 |
|---|
SCP_SMS_PREMIUM_PAYMENT
Numeric
| Distinct count | 8 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.1776029687 |
|---|---|
| Minimum | 0 |
| Maximum | 8 |
| Zeros (%) | 86.6% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 8 |
| Range | 8 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 0.497762715 |
|---|---|
| Coef of variation | 2.802671141 |
| Kurtosis | 13.88194025 |
| Mean | 0.1776029687 |
| MAD | 0.3076085204 |
| Skewness | 3.311780928 |
| Sum | 9189 |
| Variance | 0.2477677204 |
| Memory size | 404.3 KiB |
| Value | Count | Frequency (%) | |
| 0 | 44806 | 86.6% | |
| 1 | 4918 | 9.5% | |
| 2 | 1884 | 3.6% | |
| 4 | 86 | 0.2% | |
| 3 | 36 | 0.1% | |
| 5 | 5 | < 0.1% | |
| 6 | 3 | < 0.1% | |
| 8 | 1 | < 0.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 44806 | 86.6% | |
| 1 | 4918 | 9.5% | |
| 2 | 1884 | 3.6% | |
| 3 | 36 | 0.1% | |
| 4 | 86 | 0.2% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 8 | 1 | < 0.1% | |
| 6 | 3 | < 0.1% | |
| 5 | 5 | < 0.1% | |
| 4 | 86 | 0.2% | |
| 3 | 36 | 0.1% |
SCP_SMS_PROPOSAL
Numeric
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.08583467017 |
|---|---|
| Minimum | 0 |
| Maximum | 4 |
| Zeros (%) | 94.4% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 4 |
| Range | 4 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 0.3746945418 |
|---|---|
| Coef of variation | 4.365305314 |
| Kurtosis | 20.54305393 |
| Mean | 0.08583467017 |
| MAD | 0.1621069012 |
| Skewness | 4.565623941 |
| Sum | 4441 |
| Variance | 0.1403959996 |
| Memory size | 404.3 KiB |
| Value | Count | Frequency (%) | |
| 0 | 48857 | 94.4% | |
| 2 | 1482 | 2.9% | |
| 1 | 1363 | 2.6% | |
| 3 | 34 | 0.1% | |
| 4 | 3 | < 0.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 48857 | 94.4% | |
| 1 | 1363 | 2.6% | |
| 2 | 1482 | 2.9% | |
| 3 | 34 | 0.1% | |
| 4 | 3 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 4 | 3 | < 0.1% | |
| 3 | 34 | 0.1% | |
| 2 | 1482 | 2.9% | |
| 1 | 1363 | 2.6% | |
| 0 | 48857 | 94.4% |
SCP_SMS_RENEWAL
Numeric
| Distinct count | 8 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.03960262085 |
|---|---|
| Minimum | 0 |
| Maximum | 7 |
| Zeros (%) | 97.3% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 7 |
| Range | 7 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 0.2715758013 |
|---|---|
| Coef of variation | 6.857520929 |
| Kurtosis | 103.0957719 |
| Mean | 0.03960262085 |
| MAD | 0.07709418372 |
| Skewness | 8.976984809 |
| Sum | 2049 |
| Variance | 0.07375341586 |
| Memory size | 404.3 KiB |
| Value | Count | Frequency (%) | |
| 0 | 50360 | 97.3% | |
| 1 | 883 | 1.7% | |
| 2 | 381 | 0.7% | |
| 3 | 72 | 0.1% | |
| 4 | 31 | 0.1% | |
| 5 | 9 | < 0.1% | |
| 6 | 2 | < 0.1% | |
| 7 | 1 | < 0.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 50360 | 97.3% | |
| 1 | 883 | 1.7% | |
| 2 | 381 | 0.7% | |
| 3 | 72 | 0.1% | |
| 4 | 31 | 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 7 | 1 | < 0.1% | |
| 6 | 2 | < 0.1% | |
| 5 | 9 | < 0.1% | |
| 4 | 31 | 0.1% | |
| 3 | 72 | 0.1% |
SCP_SMS_SYS
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 35019 | 67.7% | |
| 1 | 16720 | 32.3% |
SCP_SMS_TERMINATION
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 101 |
| 2 | 11 |
| Value | Count | Frequency (%) | |
| 0 | 51626 | 99.8% | |
| 1 | 101 | 0.2% | |
| 2 | 11 | < 0.1% | |
| 3 | 1 | < 0.1% |
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
SCP_SMS_WEBSITE_MESSAGE
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 81 |
| Value | Count | Frequency (%) | |
| 0 | 51658 | 99.8% | |
| 1 | 81 | 0.2% |
TICKET_DATE
Categorical
| Distinct count | 404 |
|---|---|
| Unique (%) | 0.8% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 1/29/2018 0:00 | 215 |
|---|---|
| 3/7/2018 00:00 | 208 |
| 1/22/2018 0:00 | 203 |
| Other values (401) |
| Value | Count | Frequency (%) | |
| 1/29/2018 0:00 | 215 | 0.4% | |
| 3/7/2018 00:00 | 208 | 0.4% | |
| 1/22/2018 0:00 | 203 | 0.4% | |
| 1/10/2018 00:00 | 203 | 0.4% | |
| 2/26/2018 0:00 | 202 | 0.4% | |
| 1/25/2018 0:00 | 202 | 0.4% | |
| 7/9/2018 00:00 | 202 | 0.4% | |
| 1/30/2018 0:00 | 200 | 0.4% | |
| 1/2/2018 00:00 | 200 | 0.4% | |
| 1/8/2019 00:00 | 199 | 0.4% | |
| Other values (394) | 49705 | 96.1% |
| Max length | 16 |
|---|---|
| Mean length | 14.26726454 |
| Min length | 14 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
TICKET_DATE_15D
Categorical
| Distinct count | 404 |
|---|---|
| Unique (%) | 0.8% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 1/14/2018 0:00 | 215 |
|---|---|
| 2/20/2018 0:00 | 208 |
| 1/7/2018 00:00 | 203 |
| Other values (401) |
| Value | Count | Frequency (%) | |
| 1/14/2018 0:00 | 215 | 0.4% | |
| 2/20/2018 0:00 | 208 | 0.4% | |
| 1/7/2018 00:00 | 203 | 0.4% | |
| 12/26/2017 0:00 | 203 | 0.4% | |
| 2/11/2018 00:00 | 202 | 0.4% | |
| 1/10/2018 00:00 | 202 | 0.4% | |
| 6/24/2018 0:00 | 202 | 0.4% | |
| 1/15/2018 0:00 | 200 | 0.4% | |
| 12/18/2017 0:00 | 200 | 0.4% | |
| 12/24/2018 0:00 | 199 | 0.4% | |
| Other values (394) | 49705 | 96.1% |
| Max length | 16 |
|---|---|
| Mean length | 14.31179574 |
| Min length | 14 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
TKT_LOGGED_DATE
Categorical
| Distinct count | 51631 |
|---|---|
| Unique (%) | 99.8% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 20SEP2018:10:15:22 | 2 |
|---|---|
| 04JAN2018:06:45:13 | 2 |
| 14MAR2019:08:12:53 | 2 |
| Other values (51628) |
| Value | Count | Frequency (%) | |
| 20SEP2018:10:15:22 | 2 | < 0.1% | |
| 04JAN2018:06:45:13 | 2 | < 0.1% | |
| 14MAR2019:08:12:53 | 2 | < 0.1% | |
| 18AUG2018:08:55:03 | 2 | < 0.1% | |
| 28JUL2018:10:51:44 | 2 | < 0.1% | |
| 15MAR2019:05:18:13 | 2 | < 0.1% | |
| 17MAR2018:09:27:13 | 2 | < 0.1% | |
| 22MAR2018:07:56:43 | 2 | < 0.1% | |
| 03SEP2018:08:28:34 | 2 | < 0.1% | |
| 29OCT2018:05:07:35 | 2 | < 0.1% | |
| Other values (51621) | 51719 | > 99.9% |
| Max length | 18 |
|---|---|
| Mean length | 18 |
| Min length | 18 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
TKT_LOGGED_DATE1
Categorical
| Distinct count | 45386 |
|---|---|
| Unique (%) | 87.7% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 2/26/2019 7:02 | 5 |
|---|---|
| 10/17/2018 5:28 | 5 |
| 3/19/2019 12:22 | 5 |
| Other values (45383) |
| Value | Count | Frequency (%) | |
| 2/26/2019 7:02 | 5 | < 0.1% | |
| 10/17/2018 5:28 | 5 | < 0.1% | |
| 3/19/2019 12:22 | 5 | < 0.1% | |
| 8/8/2018 06:27 | 5 | < 0.1% | |
| 4/5/2018 06:44 | 5 | < 0.1% | |
| 7/16/2018 9:20 | 5 | < 0.1% | |
| 1/20/2018 5:51 | 5 | < 0.1% | |
| 2/1/2018 05:52 | 5 | < 0.1% | |
| 7/9/2018 08:17 | 4 | < 0.1% | |
| 4/27/2018 6:02 | 4 | < 0.1% | |
| Other values (45376) | 51691 | 99.9% |
| Max length | 16 |
|---|---|
| Mean length | 14.44075069 |
| Min length | 14 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
UNO_CS_COMM_COUNT
Highly correlated
This variable is highly correlated with DELIVERY_STATUS and should be ignored for analysis
| Correlation | 0.9563908587 |
|---|
UNO_CS_COMM_SYS
Highly correlated
This variable is highly correlated with COMM_VINTAGE_SCORE and should be ignored for analysis
| Correlation | 0.9118394033 |
|---|
UNO_EML_ACCOUNT_VALUE/_SURRENDER_VALUE
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 60 |
| 3 | 1 |
| Value | Count | Frequency (%) | |
| 0 | 51678 | 99.9% | |
| 1 | 60 | 0.1% | |
| 3 | 1 | < 0.1% |
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
UNO_EML_BONUS_INQUIRY
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 50 |
| 3 | 1 |
| Value | Count | Frequency (%) | |
| 0 | 51687 | 99.9% | |
| 1 | 50 | 0.1% | |
| 3 | 1 | < 0.1% | |
| 2 | 1 | < 0.1% |
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
UNO_EML_CAMPAIGN_RELATED_INFORMATION
Numeric
| Distinct count | 6 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.003421017028 |
|---|---|
| Minimum | 0 |
| Maximum | 5 |
| Zeros (%) | 99.7% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 5 |
| Range | 5 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 0.07039624874 |
|---|---|
| Coef of variation | 20.57757917 |
| Kurtosis | 1270.305004 |
| Mean | 0.003421017028 |
| MAD | 0.006822065615 |
| Skewness | 29.60723533 |
| Sum | 177 |
| Variance | 0.004955631837 |
| Memory size | 404.3 KiB |
| Value | Count | Frequency (%) | |
| 0 | 51588 | 99.7% | |
| 1 | 134 | 0.3% | |
| 2 | 12 | < 0.1% | |
| 4 | 2 | < 0.1% | |
| 3 | 2 | < 0.1% | |
| 5 | 1 | < 0.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 51588 | 99.7% | |
| 1 | 134 | 0.3% | |
| 2 | 12 | < 0.1% | |
| 3 | 2 | < 0.1% | |
| 4 | 2 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 5 | 1 | < 0.1% | |
| 4 | 2 | < 0.1% | |
| 3 | 2 | < 0.1% | |
| 2 | 12 | < 0.1% | |
| 1 | 134 | 0.3% |
UNO_EML_DOCUMENTATION_REQUIREMENT_FOR_POS_CHANGES
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 53 |
| 3 | 1 |
| Value | Count | Frequency (%) | |
| 0 | 51684 | 99.9% | |
| 1 | 53 | 0.1% | |
| 3 | 1 | < 0.1% | |
| 2 | 1 | < 0.1% |
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
UNO_EML_DUE_DATE/_AMOUNT
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 135 |
| 2 | 5 |
| Value | Count | Frequency (%) | |
| 0 | 51599 | 99.7% | |
| 1 | 135 | 0.3% | |
| 2 | 5 | < 0.1% |
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
UNO_EML_ECS_/_CREDIT_CARD_INQUIRY
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 27 |
| 2 | 1 |
| Value | Count | Frequency (%) | |
| 0 | 51711 | 99.9% | |
| 1 | 27 | 0.1% | |
| 2 | 1 | < 0.1% |
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
UNO_EML_ECS_DEBIT_INCORRECT_/_NOT_DONE
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 32 |
| 2 | 1 |
| Value | Count | Frequency (%) | |
| 0 | 51706 | 99.9% | |
| 1 | 32 | 0.1% | |
| 2 | 1 | < 0.1% |
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
UNO_EML_FOLLOW_UP_-_STATUS_OF_PROPOSAL
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 44 |
| 2 | 2 |
| Value | Count | Frequency (%) | |
| 0 | 51693 | 99.9% | |
| 1 | 44 | 0.1% | |
| 2 | 2 | < 0.1% |
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
UNO_EML_KYC_DOCUMENT_STATUS
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 45 |
| 2 | 2 |
| Value | Count | Frequency (%) | |
| 0 | 51692 | 99.9% | |
| 1 | 45 | 0.1% | |
| 2 | 2 | < 0.1% |
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
UNO_EML_MISS-SELLING_/_FRAUD_BY_AGENT
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 14 |
| 3 | 1 |
| Value | Count | Frequency (%) | |
| 0 | 51723 | > 99.9% | |
| 1 | 14 | < 0.1% | |
| 3 | 1 | < 0.1% | |
| 2 | 1 | < 0.1% |
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
UNO_EML_OTHERS
Numeric
| Distinct count | 8 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.04122615435 |
|---|---|
| Minimum | 0 |
| Maximum | 7 |
| Zeros (%) | 97.0% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 7 |
| Range | 7 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 0.2671705809 |
|---|---|
| Coef of variation | 6.480608854 |
| Kurtosis | 108.1798278 |
| Mean | 0.04122615435 |
| MAD | 0.07997582312 |
| Skewness | 8.913708665 |
| Sum | 2133 |
| Variance | 0.07138011931 |
| Memory size | 404.3 KiB |
| Value | Count | Frequency (%) | |
| 0 | 50185 | 97.0% | |
| 1 | 1140 | 2.2% | |
| 2 | 302 | 0.6% | |
| 3 | 77 | 0.1% | |
| 4 | 24 | < 0.1% | |
| 5 | 6 | < 0.1% | |
| 6 | 3 | < 0.1% | |
| 7 | 2 | < 0.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 50185 | 97.0% | |
| 1 | 1140 | 2.2% | |
| 2 | 302 | 0.6% | |
| 3 | 77 | 0.1% | |
| 4 | 24 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 7 | 2 | < 0.1% | |
| 6 | 3 | < 0.1% | |
| 5 | 6 | < 0.1% | |
| 4 | 24 | < 0.1% | |
| 3 | 77 | 0.1% |
UNO_EML_PERSONAL_UPDATE
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 31 |
| 2 | 2 |
| Value | Count | Frequency (%) | |
| 0 | 51706 | 99.9% | |
| 1 | 31 | 0.1% | |
| 2 | 2 | < 0.1% |
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
UNO_EML_POLICY_BENEFITS_/_DEATH_BENEFIT
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 64 |
| 2 | 1 |
| Value | Count | Frequency (%) | |
| 0 | 51674 | 99.9% | |
| 1 | 64 | 0.1% | |
| 2 | 1 | < 0.1% |
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
UNO_EML_POLICY_SERVICING_-_CLARIFICATION/_FOLLOW_UP
Numeric
| Distinct count | 6 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.007151278533 |
|---|---|
| Minimum | 0 |
| Maximum | 5 |
| Zeros (%) | 99.4% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 5 |
| Range | 5 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 0.09645560879 |
|---|---|
| Coef of variation | 13.48788309 |
| Kurtosis | 557.678325 |
| Mean | 0.007151278533 |
| MAD | 0.01421050365 |
| Skewness | 18.98991265 |
| Sum | 370 |
| Variance | 0.009303684467 |
| Memory size | 404.3 KiB |
| Value | Count | Frequency (%) | |
| 0 | 51406 | 99.4% | |
| 1 | 308 | 0.6% | |
| 2 | 19 | < 0.1% | |
| 5 | 2 | < 0.1% | |
| 4 | 2 | < 0.1% | |
| 3 | 2 | < 0.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 51406 | 99.4% | |
| 1 | 308 | 0.6% | |
| 2 | 19 | < 0.1% | |
| 3 | 2 | < 0.1% | |
| 4 | 2 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 5 | 2 | < 0.1% | |
| 4 | 2 | < 0.1% | |
| 3 | 2 | < 0.1% | |
| 2 | 19 | < 0.1% | |
| 1 | 308 | 0.6% |
UNO_EML_POLICY_STATUS_-_ACTIVE_/_LAPSE
Numeric
| Distinct count | 6 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.01107481784 |
|---|---|
| Minimum | 0 |
| Maximum | 5 |
| Zeros (%) | 99.1% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 5 |
| Range | 5 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 0.1237761714 |
|---|---|
| Coef of variation | 11.17636183 |
| Kurtosis | 267.163646 |
| Mean | 0.01107481784 |
| MAD | 0.02194243368 |
| Skewness | 14.25567369 |
| Sum | 573 |
| Variance | 0.0153205406 |
| Memory size | 404.3 KiB |
| Value | Count | Frequency (%) | |
| 0 | 51255 | 99.1% | |
| 1 | 415 | 0.8% | |
| 2 | 52 | 0.1% | |
| 3 | 15 | < 0.1% | |
| 5 | 1 | < 0.1% | |
| 4 | 1 | < 0.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 51255 | 99.1% | |
| 1 | 415 | 0.8% | |
| 2 | 52 | 0.1% | |
| 3 | 15 | < 0.1% | |
| 4 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 5 | 1 | < 0.1% | |
| 4 | 1 | < 0.1% | |
| 3 | 15 | < 0.1% | |
| 2 | 52 | 0.1% | |
| 1 | 415 | 0.8% |
UNO_EML_POS_REQUEST_DELAY_/_ERROR
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 25 |
| 2 | 3 |
| Value | Count | Frequency (%) | |
| 0 | 51711 | 99.9% | |
| 1 | 25 | < 0.1% | |
| 2 | 3 | < 0.1% |
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
UNO_EML_PROCESSING_DELAY_/_ERROR
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 90 |
| 2 | 10 |
| Value | Count | Frequency (%) | |
| 0 | 51638 | 99.8% | |
| 1 | 90 | 0.2% | |
| 2 | 10 | < 0.1% | |
| 4 | 1 | < 0.1% |
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
UNO_EML_SYS
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 2732 |
| Value | Count | Frequency (%) | |
| 0 | 49007 | 94.7% | |
| 1 | 2732 | 5.3% |
UNO_EML_THIRD_PARTY_VERIFICATION
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 25 |
| 2 | 1 |
| Value | Count | Frequency (%) | |
| 0 | 51713 | 99.9% | |
| 1 | 25 | < 0.1% | |
| 2 | 1 | < 0.1% |
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
First rows
| CLEAN_INTENT | CLI_EDUCATION_CAT_01 | CLI_EDUCATION_CAT_02 | CLI_EDUCATION_CAT_03 | CLI_EDUCATION_CAT_04 | CLI_HNI_IND_L | CLI_HNI_IND_N | CLI_HNI_IND_Y | CLI_OCCUPATION_CAT_01 | CLI_OCCUPATION_CAT_02 | CLI_OCCUPATION_CAT_03 | CLI_OCCUPATION_CAT_04 | CLI_OCCUPATION_CAT_05 | CLI_OCCUPATION_CAT_06 | CLI_OCCUPATION_CAT_07 | CLI_OCCUPATION_CAT_08 | CLI_SNGL_MLTPL_PLCYHLDR_FLG_MULTIPLE | CLI_SNGL_MLTPL_PLCYHLDR_FLG_SINGLE | COMM_TKT_DT | COMM_VINTAGE_SCORE | DELIVERY_STATUS | DUE_DATE_PAID | DUE_DATE_SYS | DUE_STS_SYS | DUE_VINTAGE_SCORE | ECS_FLAG_No | ECS_FLAG_Yes | HELP_LINE_ACCOUNTVALUE/SURRENDERVALUE | HELP_LINE_BONUSINQUIRY | HELP_LINE_DUEDATE/AMOUNT | HELP_LINE_ECS/CREDITCARDINQUIRY | HELP_LINE_LOANENQUIRY | HELP_LINE_OTHERS | HELP_LINE_PAYMENTPROCEDURE/ONLINEPAYMENTPROCEDURE | HELP_LINE_POLICYPACKDISPATCHSTATUS/CLARIFICATION | HELP_LINE_POLICYSTATUS-ACTIVE/LAPSE | HELP_LINE_POSREQUESTSTATUSREQUIRED | HELP_LINE_PREMIUMPAYMENT/CHEQUERECEIVEDENQUIRY | HELP_LINE_PREMIUMRECEIPTREQUEST | HELP_LINE_PROBABLESURRENDER | HELP_LINE_STATUSOFTHEPROPOSAL | HELP_LINE_SYS | INCOME_BUK_01 | INCOME_BUK_02 | INCOME_BUK_03 | INCOME_BUK_04 | INCOME_BUK_05 | ind_surr | IVR_ACCOUNT_VALUE/_SURRENDER_VALUE | IVR_OTHERS | IVR_POLICY_STATUS_-_ACTIVE_/_LAPSE | IVR_PREMIUM_RECEIPT_REQUEST | IVR_SYS | Lock_in_ind | mapped_pol_id | MEGA_MEGA_OTHERS | MEGA_SCP_MG_1 | MEGA_SCP_MG_10 | MEGA_SCP_MG_11 | MEGA_SCP_MG_12 | MEGA_SCP_MG_13 | MEGA_SCP_MG_14 | MEGA_SCP_MG_2 | MEGA_SCP_MG_3 | MEGA_SCP_MG_4 | MEGA_SCP_MG_5 | MEGA_SCP_MG_6 | MEGA_SCP_MG_7 | MEGA_SCP_MG_9 | MEGA_SYS | MON_BNC_CHQ_VINTAGE_SCORE | MON_BOUNCE_COUNT | MON_CLEARANCE_COUNT | MON_CLR_CHQ_VINTAGE_SCORE | MON_TKT_BOUNCE_DATE | MON_TKT_CLEARNACE_DATE | MY_MON_BNC_SYS | MY_MON_CLR_SYS | new_policy | PLAN_CAT_01 | PLAN_CAT_02 | PLAN_CAT_03 | PLAN_CAT_04 | PLAN_FAMILY_01 | PLAN_FAMILY_02 | PLAN_FAMILY_03 | PLAN_FAMILY_04 | PLAN_FAMILY_05 | PLAN_FAMILY_06 | PLAN_FAMILY_07 | PLAN_FAMILY_08 | PLAN_FAMILY_09 | PLAN_FAMILY_10 | PLAN_FAMILY_11 | PLAN_FAMILY_12 | PLAN_FAMILY_13 | PLAN_FAMILY_14 | PLAN_FAMILY_15 | PLAN_FAMILY_16 | PLAN_TYPE_01 | PLAN_TYPE_02 | PLAN_TYPE_03 | PLAN_TYPE_04 | PLAN_TYPE_05 | PLAN_TYPE_06 | PLAN_TYPE_07 | POL_COV_TERM | POL_PPT | POL_RIDER_COUNT | POLICY_CHNL_01 | POLICY_CHNL_02 | POLICY_CHNL_03 | POLICY_CHNL_04 | POLICY_CHNL_05 | POLICY_CHNL_06 | POS_COUNT | POS_SYS_TOUCH_PT | POS_TKT_LOGGED_DATE1 | POS_VINTAGE_SCORE | REN_COUNT | REN_SYS_TOUCH_PT | REN_TKT_LOGGED_DATE1 | REN_VINTAGE_SCORE | SCP_EML_SCP_EM_1 | SCP_EML_SCP_EM_10 | SCP_EML_SCP_EM_13 | SCP_EML_SCP_EM_14 | SCP_EML_SCP_EM_15 | SCP_EML_SCP_EM_16 | SCP_EML_SCP_EM_17 | SCP_EML_SCP_EM_18 | SCP_EML_SCP_EM_19 | SCP_EML_SCP_EM_2 | SCP_EML_SCP_EM_3 | SCP_EML_SCP_EM_4 | SCP_EML_SCP_EM_5 | SCP_EML_SCP_EM_6 | SCP_EML_SCP_EM_7 | SCP_EML_SCP_EM_8 | SCP_EML_SCP_EM_9 | SCP_EML_SCP_EML_OTHERS | SCP_EML_SYS | SCP_SMS_AGENT_-_OTHER | SCP_SMS_CUSTOMER_AWARENESS | SCP_SMS_LAPSATION_&_REVIVAL | SCP_SMS_MOBILE_NUMBER_LINK | SCP_SMS_PAYMENT | SCP_SMS_PAYMENT_MODE | SCP_SMS_POS | SCP_SMS_PREMIUM_PAYMENT | SCP_SMS_PROPOSAL | SCP_SMS_RENEWAL | SCP_SMS_SYS | SCP_SMS_TERMINATION | SCP_SMS_WEBSITE_MESSAGE | TICKET_DATE | TICKET_DATE_15D | TKT_LOGGED_DATE | TKT_LOGGED_DATE1 | UNO_CS_COMM_COUNT | UNO_CS_COMM_SYS | UNO_EML_ACCOUNT_VALUE/_SURRENDER_VALUE | UNO_EML_BONUS_INQUIRY | UNO_EML_CAMPAIGN_RELATED_INFORMATION | UNO_EML_DOCUMENTATION_REQUIREMENT_FOR_POS_CHANGES | UNO_EML_DUE_DATE/_AMOUNT | UNO_EML_ECS_/_CREDIT_CARD_INQUIRY | UNO_EML_ECS_DEBIT_INCORRECT_/_NOT_DONE | UNO_EML_FOLLOW_UP_-_STATUS_OF_PROPOSAL | UNO_EML_KYC_DOCUMENT_STATUS | UNO_EML_MISS-SELLING_/_FRAUD_BY_AGENT | UNO_EML_OTHERS | UNO_EML_PERSONAL_UPDATE | UNO_EML_POLICY_BENEFITS_/_DEATH_BENEFIT | UNO_EML_POLICY_SERVICING_-_CLARIFICATION/_FOLLOW_UP | UNO_EML_POLICY_STATUS_-_ACTIVE_/_LAPSE | UNO_EML_POS_REQUEST_DELAY_/_ERROR | UNO_EML_PROCESSING_DELAY_/_ERROR | UNO_EML_SYS | UNO_EML_THIRD_PARTY_VERIFICATION | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | DUEDATE/AMOUNT | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ZTAEBFBFOOVMWLAEOO | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 90 | 999 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 1 | 6/12/2018 00:00 | 14 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 6/13/2018 0:00 | 5/29/2018 0:00 | 13JUN2018:07:33:02 | 6/13/2018 7:33 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 1 | PROBABLESURRENDER | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 6/9/2018 00:00 | 13 | 6 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | WLCGBFZTWLXRZTVMOO | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 999 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 6/11/2018 00:00 | 5/27/2018 0:00 | 11JUN2018:11:23:47 | 6/11/2018 11:23 | 6 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 2 | PAYMENTPROCEDURE/ONLINEPAYMENTPROCEDURE | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 4/19/2018 0:00 | 1 | 1 | 13 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | CGAEVMBFXRVMOOAEZT | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 20 | 999 | 3 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 4/13/2018 0:00 | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 0 | 0 | 4/21/2018 0:00 | 4/6/2018 00:00 | 21APR2018:05:00:31 | 4/21/2018 5:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 3 | PROBABLESURRENDER | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3/27/2019 0:00 | 1 | 1 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | XRZTAEVMWLZTXRDKXR | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3/30/2019 0:00 | 3/15/2019 0:00 | 30MAR2019:10:24:12 | 3/30/2019 10:24 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 4 | POLICYSTATUS-ACTIVE/LAPSE | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | BFDKCGXRYSAEBFCGXR | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 20 | 10 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 11/13/2018 0:00 | 10/29/2018 0:00 | 13NOV2018:05:42:28 | 11/13/2018 5:42 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 5 | DUEDATE/AMOUNT | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | XRWLWLBFDKCGYSVMZT | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 20 | 6 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 6/12/2018 00:00 | 5/28/2018 0:00 | 12JUN2018:04:26:03 | 6/12/2018 04:26 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 6 | BONUSINQUIRY | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ZTAEZTVMDKAEXRXRWL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2/9/2018 00:00 | 1/25/2018 0:00 | 09FEB2018:12:27:05 | 2/9/2018 12:27 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 7 | POSREQUESTSTATUSREQUIRED | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 11/14/2018 0:00 | 10 | 2 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | DKDKVMWLAEXRYSVMDK | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 999 | 3 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 11/13/2018 0:00 | 9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 11/19/2018 0:00 | 11/4/2018 00:00 | 19NOV2018:06:59:53 | 11/19/2018 6:59 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 8 | DUEDATE/AMOUNT | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5/12/2018 00:00 | 5 | 2 | 5/11/2018 00:00 | 1 | 1 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 1 | 1 | XRAEZTOOOOOOWLVMZT | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 5/17/2018 0:00 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 5/22/2018 0:00 | 5/7/2018 00:00 | 22MAY2018:10:15:01 | 5/22/2018 10:15 | 3 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 9 | PREMIUMRECEIPTREQUEST | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | DKOOZTCGDKBFCGCGDK | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 2 | 0 | 10/10/2018 00:00 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 20 | 999 | 2 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10/23/2018 0:00 | 10/8/2018 00:00 | 23OCT2018:06:58:52 | 10/23/2018 6:58 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Last rows
| CLEAN_INTENT | CLI_EDUCATION_CAT_01 | CLI_EDUCATION_CAT_02 | CLI_EDUCATION_CAT_03 | CLI_EDUCATION_CAT_04 | CLI_HNI_IND_L | CLI_HNI_IND_N | CLI_HNI_IND_Y | CLI_OCCUPATION_CAT_01 | CLI_OCCUPATION_CAT_02 | CLI_OCCUPATION_CAT_03 | CLI_OCCUPATION_CAT_04 | CLI_OCCUPATION_CAT_05 | CLI_OCCUPATION_CAT_06 | CLI_OCCUPATION_CAT_07 | CLI_OCCUPATION_CAT_08 | CLI_SNGL_MLTPL_PLCYHLDR_FLG_MULTIPLE | CLI_SNGL_MLTPL_PLCYHLDR_FLG_SINGLE | COMM_TKT_DT | COMM_VINTAGE_SCORE | DELIVERY_STATUS | DUE_DATE_PAID | DUE_DATE_SYS | DUE_STS_SYS | DUE_VINTAGE_SCORE | ECS_FLAG_No | ECS_FLAG_Yes | HELP_LINE_ACCOUNTVALUE/SURRENDERVALUE | HELP_LINE_BONUSINQUIRY | HELP_LINE_DUEDATE/AMOUNT | HELP_LINE_ECS/CREDITCARDINQUIRY | HELP_LINE_LOANENQUIRY | HELP_LINE_OTHERS | HELP_LINE_PAYMENTPROCEDURE/ONLINEPAYMENTPROCEDURE | HELP_LINE_POLICYPACKDISPATCHSTATUS/CLARIFICATION | HELP_LINE_POLICYSTATUS-ACTIVE/LAPSE | HELP_LINE_POSREQUESTSTATUSREQUIRED | HELP_LINE_PREMIUMPAYMENT/CHEQUERECEIVEDENQUIRY | HELP_LINE_PREMIUMRECEIPTREQUEST | HELP_LINE_PROBABLESURRENDER | HELP_LINE_STATUSOFTHEPROPOSAL | HELP_LINE_SYS | INCOME_BUK_01 | INCOME_BUK_02 | INCOME_BUK_03 | INCOME_BUK_04 | INCOME_BUK_05 | ind_surr | IVR_ACCOUNT_VALUE/_SURRENDER_VALUE | IVR_OTHERS | IVR_POLICY_STATUS_-_ACTIVE_/_LAPSE | IVR_PREMIUM_RECEIPT_REQUEST | IVR_SYS | Lock_in_ind | mapped_pol_id | MEGA_MEGA_OTHERS | MEGA_SCP_MG_1 | MEGA_SCP_MG_10 | MEGA_SCP_MG_11 | MEGA_SCP_MG_12 | MEGA_SCP_MG_13 | MEGA_SCP_MG_14 | MEGA_SCP_MG_2 | MEGA_SCP_MG_3 | MEGA_SCP_MG_4 | MEGA_SCP_MG_5 | MEGA_SCP_MG_6 | MEGA_SCP_MG_7 | MEGA_SCP_MG_9 | MEGA_SYS | MON_BNC_CHQ_VINTAGE_SCORE | MON_BOUNCE_COUNT | MON_CLEARANCE_COUNT | MON_CLR_CHQ_VINTAGE_SCORE | MON_TKT_BOUNCE_DATE | MON_TKT_CLEARNACE_DATE | MY_MON_BNC_SYS | MY_MON_CLR_SYS | new_policy | PLAN_CAT_01 | PLAN_CAT_02 | PLAN_CAT_03 | PLAN_CAT_04 | PLAN_FAMILY_01 | PLAN_FAMILY_02 | PLAN_FAMILY_03 | PLAN_FAMILY_04 | PLAN_FAMILY_05 | PLAN_FAMILY_06 | PLAN_FAMILY_07 | PLAN_FAMILY_08 | PLAN_FAMILY_09 | PLAN_FAMILY_10 | PLAN_FAMILY_11 | PLAN_FAMILY_12 | PLAN_FAMILY_13 | PLAN_FAMILY_14 | PLAN_FAMILY_15 | PLAN_FAMILY_16 | PLAN_TYPE_01 | PLAN_TYPE_02 | PLAN_TYPE_03 | PLAN_TYPE_04 | PLAN_TYPE_05 | PLAN_TYPE_06 | PLAN_TYPE_07 | POL_COV_TERM | POL_PPT | POL_RIDER_COUNT | POLICY_CHNL_01 | POLICY_CHNL_02 | POLICY_CHNL_03 | POLICY_CHNL_04 | POLICY_CHNL_05 | POLICY_CHNL_06 | POS_COUNT | POS_SYS_TOUCH_PT | POS_TKT_LOGGED_DATE1 | POS_VINTAGE_SCORE | REN_COUNT | REN_SYS_TOUCH_PT | REN_TKT_LOGGED_DATE1 | REN_VINTAGE_SCORE | SCP_EML_SCP_EM_1 | SCP_EML_SCP_EM_10 | SCP_EML_SCP_EM_13 | SCP_EML_SCP_EM_14 | SCP_EML_SCP_EM_15 | SCP_EML_SCP_EM_16 | SCP_EML_SCP_EM_17 | SCP_EML_SCP_EM_18 | SCP_EML_SCP_EM_19 | SCP_EML_SCP_EM_2 | SCP_EML_SCP_EM_3 | SCP_EML_SCP_EM_4 | SCP_EML_SCP_EM_5 | SCP_EML_SCP_EM_6 | SCP_EML_SCP_EM_7 | SCP_EML_SCP_EM_8 | SCP_EML_SCP_EM_9 | SCP_EML_SCP_EML_OTHERS | SCP_EML_SYS | SCP_SMS_AGENT_-_OTHER | SCP_SMS_CUSTOMER_AWARENESS | SCP_SMS_LAPSATION_&_REVIVAL | SCP_SMS_MOBILE_NUMBER_LINK | SCP_SMS_PAYMENT | SCP_SMS_PAYMENT_MODE | SCP_SMS_POS | SCP_SMS_PREMIUM_PAYMENT | SCP_SMS_PROPOSAL | SCP_SMS_RENEWAL | SCP_SMS_SYS | SCP_SMS_TERMINATION | SCP_SMS_WEBSITE_MESSAGE | TICKET_DATE | TICKET_DATE_15D | TKT_LOGGED_DATE | TKT_LOGGED_DATE1 | UNO_CS_COMM_COUNT | UNO_CS_COMM_SYS | UNO_EML_ACCOUNT_VALUE/_SURRENDER_VALUE | UNO_EML_BONUS_INQUIRY | UNO_EML_CAMPAIGN_RELATED_INFORMATION | UNO_EML_DOCUMENTATION_REQUIREMENT_FOR_POS_CHANGES | UNO_EML_DUE_DATE/_AMOUNT | UNO_EML_ECS_/_CREDIT_CARD_INQUIRY | UNO_EML_ECS_DEBIT_INCORRECT_/_NOT_DONE | UNO_EML_FOLLOW_UP_-_STATUS_OF_PROPOSAL | UNO_EML_KYC_DOCUMENT_STATUS | UNO_EML_MISS-SELLING_/_FRAUD_BY_AGENT | UNO_EML_OTHERS | UNO_EML_PERSONAL_UPDATE | UNO_EML_POLICY_BENEFITS_/_DEATH_BENEFIT | UNO_EML_POLICY_SERVICING_-_CLARIFICATION/_FOLLOW_UP | UNO_EML_POLICY_STATUS_-_ACTIVE_/_LAPSE | UNO_EML_POS_REQUEST_DELAY_/_ERROR | UNO_EML_PROCESSING_DELAY_/_ERROR | UNO_EML_SYS | UNO_EML_THIRD_PARTY_VERIFICATION | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 51729 | BONUSINQUIRY | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | BFCGVMDKYSVMBFOOCG | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 77 | 999 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 1/18/2018 0:00 | 14 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1/19/2018 0:00 | 1/4/2018 00:00 | 19JAN2018:03:46:51 | 1/19/2018 3:46 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 51730 | STATUSOFTHEPROPOSAL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | XRYSBFDKWLVMYSCGCG | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9/19/2018 0:00 | 9/4/2018 00:00 | 19SEP2018:10:59:42 | 9/19/2018 10:59 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 51731 | PREMIUMRECEIPTREQUEST | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 10/27/2018 0:00 | 6 | 1 | 10/31/2018 0:00 | 1 | 1 | 10 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | WLOOWLWLCGWLXRBFXR | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 8 | 0 | 10/29/2018 0:00 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 70 | 999 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 11/5/2018 00:00 | 10/21/2018 0:00 | 05NOV2018:05:20:43 | 11/5/2018 05:20 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 51732 | ECS/CREDITCARDINQUIRY | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 5/7/2018 00:00 | 12 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | YSOOXRAEOOBFZTZTCG | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 10 | 5 | 3 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 5 | 1 | 5/10/2018 00:00 | 15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 0 | 0 | 5/10/2018 00:00 | 4/25/2018 0:00 | 10MAY2018:08:17:57 | 5/10/2018 08:17 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 51733 | ACCOUNTVALUE/SURRENDERVALUE | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | DKOOOOOOVMYSBFYSCG | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 15 | 7 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 6/22/2018 0:00 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7/2/2018 00:00 | 6/17/2018 0:00 | 02JUL2018:06:19:19 | 7/2/2018 06:19 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 51734 | PREMIUMPAYMENT/CHEQUERECEIVEDENQUIRY | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | DKDKDKWLVMYSYSDKWL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 19 | 5 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 6/19/2018 0:00 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 6/22/2018 0:00 | 6/7/2018 00:00 | 22JUN2018:03:57:47 | 6/22/2018 3:57 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 51735 | DUEDATE/AMOUNT | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | DKOOAEAEOOYSVMXRBF | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 20 | 999 | 4 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1/15/2019 0:00 | 14 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1/16/2019 0:00 | 1/1/2019 00:00 | 16JAN2019:10:14:33 | 1/16/2019 10:14 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 51736 | ACCOUNTVALUE/SURRENDERVALUE | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | BFXRXRWLVMXRWLVMWL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 25 | 12 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10/31/2018 0:00 | 10/16/2018 0:00 | 31OCT2018:06:32:50 | 10/31/2018 6:32 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 51737 | STATUSOFTHEPROPOSAL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 11/26/2018 0:00 | 14 | 3 | 11/13/2018 0:00 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | XRZTOOAEAEYSWLDKXR | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 15 | 0 | 11/27/2018 0:00 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 1 | 0 | 0 | 11/27/2018 0:00 | 11/12/2018 00:00 | 27NOV2018:07:55:35 | 11/27/2018 7:55 | 8 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 51738 | ACCOUNTVALUE/SURRENDERVALUE | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | WLWLXROOWLYSVMBFAE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 20 | 6 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7/2/2018 00:00 | 6/17/2018 0:00 | 02JUL2018:05:23:38 | 7/2/2018 05:23 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |